October 2, 2006 at 12:45 pm
I want to kick off three jobs and have them run at the same time (in parallel) after another job ends successfully. I know how to kick off one job (i.e. sp_start_job), but how would I architect the step to kick off all three jobs at the same time, rather than one-right-after another?
Lezza
October 3, 2006 at 4:22 am
I would run them one right after another.... depending on the process... ANy specific reason for having to kick off all three in a go?
October 3, 2006 at 11:17 am
sp_start_job doesn't wait for the job to finish, does it? So if you have three in a row, the jobs will all start within milliseconds of each other.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
October 5, 2006 at 8:58 am
Thanks for the replies! We want them to run in parallel rather than in serial because we are trying to reduce a load window and these three loads don't have anything to do with each other structurally.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply