Post reply

SQL Job Dependencay

  • November 4, 2010 at 9:09 am

    #231212

    Hi All,

    I have had a issue with a a job that inserts and removes data from different tables.

    The job is now split into 2 jobs, after Job_A completes successfully there is a time period of about 6 minutes before Job_B can be executed. I have set the schedule so that it will execute 10 minutes after Job_A starts because it takes about 3 minutes for Job_A to complete. The big issue is that there might be times that Job_A will be executing longer but Job_B need to execute 6 minutes after Job_A completed.

    If Job_B start to early all the data that needs to be removed doesn't get removed and it is very critical that it execute in this way.

    Any advice will be much appreciated.

    Thank you.

  • November 4, 2010 at 9:11 am

    #1246627

    Set them up as sequential steps in a single job.

    If you need to add a delay in between, set that up as step in between.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • November 4, 2010 at 9:27 am

    #1246635

    GSquared (11/4/2010)

    Set them up as sequential steps in a single job.

    If you need to add a delay in between, set that up as step in between.

    Yep - include a WAITFOR step in between if you need a delay (but it doesn't sound like you do).

    Or if they absolutely need to be separate jobs, unschedule the second job and include the t-sql to start the job at the end of the first.

  • November 4, 2010 at 9:32 am

    #1246636

    Thanks, all is now back into 1 job with a waitfor delay in the beginning of the second step and it is working fine!

    Thanks again!

  • November 5, 2010 at 6:17 am

    #1247066

    You're welcome.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply