June 26, 2014 at 3:08 am
HI
I have a job which runs every two minutes.
I need to schedule it in such a way that until first run finishes second run should no be invoked.
[i,e] For eg: If run1 taking more than 2 minutes to complete ,Run2 should be invoked only after run1 is done.
Please help
June 26, 2014 at 3:25 am
You can use perhaps this piece of code:
Limit SSIS Package Execution At Any One Time
Put it in a for loop and loop until you can execute the package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 26, 2014 at 3:26 am
That's how it works. If your job is still running at its next scheduled time, it won't run again until the next scheduled time after that (unless, of course, it's still running then, in which case it'll wait again).
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply