Post reply

SSIS JOb Scheduling

  • June 26, 2014 at 3:08 am

    #287163

    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

    #1724969

    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

    #1724970

    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