put a 15 minute delay in the next execution of a start loop

ep_datastage · Post by **ep_datastage** » Mon Jun 05, 2017 3:37 pm

trying to have a 15 minute delay between each execution of a start and end loop.

How can I accomplish that.

Thanks

Rick

PaulVL · Post by **PaulVL** » Mon Jun 05, 2017 4:33 pm

execute stage "sleep 900";

15*60 = 900

ray.wurlod · Post by **ray.wurlod** » Mon Jun 05, 2017 6:14 pm

I read between the lines that you require the more elegant solution of sleeping until the next 15 minute point on the clock.

The easiest way (in my opinion) to accomplish this is in a Routine activity, using a routine that calculates the time to which to sleep and issues an appropriate SLEEP command, for example SLEEP 10:45.

chulett · Post by **chulett** » Tue Jun 06, 2017 6:34 am

Did exactly that many moons ago when we had a need for a looping sequence to run something every 15 minutes on the mark. So built a routine to check to see how long the previous iteration took (what time did it end) and then do a little time math to know how long to sleep to get to the next quarter hour.

cdp · Post by **cdp** » Tue Jun 13, 2017 4:42 pm

I haven't read between the lines, so this might not be what you have asked for, but anyway..
An option could be to have a "Wait for file Activity" Stage just before your 'End Loop' stage:

- Filename: /ds_project/file_does_not_exist.txt
- Wait for file to appear for 15 minutes (will never happen)
- Set Trigger to: "Failed - (Conditional)" for the link that goes to the 'End Loop' stage

--> Will wait 15 minutes before exiting each Loop.