topic WAIT UNTIL statement in Application Development and Automation Discussions

WAIT UNTIL statement

praveen_kumar194 — Wed, 04 Dec 2013 01:10:07 GMT

Hi All,

We got one requirement where we have one report program which will send out emails in bulk ( 400 K ). The entire logic sending out email is located inside a loop condition. Our business wants to send 10k mails at a time and there should be a gap of 3 hours and then send again 10k mails. Like this job has to run.

Is it ok to put WAIT statement for 3 hours at the end of the loop to control the duration. I really search for side effects wait statement but could not get any answer. Please give your valuable input.

Re: WAIT UNTIL statement

JerryWang — Wed, 04 Dec 2013 02:41:41 GMT

Hi Praveen,

why don't you schedule the report as a background job with time interval = 3 hours?

Best regards,

Jerry

Re: WAIT UNTIL statement

Katan — Wed, 04 Dec 2013 02:59:30 GMT

Hi Praveen,

You could actually schedule the program within itself to start again in three hours time. See FM JOB_OPEN and check out its documentation, which explains it's use.

Sending out 400K emails is quite a lot. Double check if this is absolutely necessary and hopefully it is not something that needs to be periodically repeated, as I can see that this solution will only smooth over any performance issues you are facing without really tackling the problem.

Regards,

Katan

Re: WAIT UNTIL statement

JJosh — Wed, 04 Dec 2013 04:09:18 GMT

Hi Praveen,

I got a suggestion.

Making a program wait for hours does not make sense.

Add a condition for sending only 10K emails at a time and schedule the report for every 3 hrs and in the next batch send the next 10K emails.

Here you might have an issue for selecting the records for the 2nd batch execution. To solve this for already processed records, you can update a STATUS field in table. If this is a standard table, then store the fetched records to a temp table and set the status, so that you can cross check the already processed records and daily u can refresh this temp table based on creation date.

Regards,

Josh

Re: WAIT UNTIL statement

nabheetscn — Wed, 04 Dec 2013 05:08:24 GMT

Hi Praveen

You can schedule a job which will start after 3 hours to send the next set of emails. It will be sort of recursive till all email are send.

First time program run it send 10K emails and schedule a job for the program to start after 3 hours to send next 10K. Same goes on till all are sent. You have to keep track of what all have been sent and what is pending

Nabheet

Re: WAIT UNTIL statement

faisal_pc — Wed, 04 Dec 2013 06:05:41 GMT

Hi Praveen,

Wait Until doesn't seems to be working for 3 hours. Schedule a job to run in 3 hours with different variants. I mean in the first variant give first 10000 mail recipient addresses, second one next 10000 addresses and so on..

Thanks,

Faisal

Re: WAIT UNTIL statement

koolspy_ultimate — Wed, 04 Dec 2013 06:45:50 GMT

hi,

Try with different selection parameters with report RSCONN01 (Schedule this report in BG as per your required intervals).

Regards,

Madhumahesh.

Re: WAIT UNTIL statement

yogendra_bhaskar — Wed, 04 Dec 2013 07:57:31 GMT

This message was moderated.

Re: WAIT UNTIL statement

RaymondGiuseppi — Mon, 30 Dec 2013 10:30:12 GMT

Don't call RSCONN01 within your report, but change value of "maximal Maximum No. of Send Requests" in a copy of variant SAP&CONNECTINT or similar standard variant, then schedule it with a period of 3 hours.

Regards,

Raymond