• Is there a reason why you have it set up as multiple jobs instead of just one job with multiple steps? If there is, I'm mot saying it's the best way to do this, but could you "daisy chain" them? Remove your job that fires off all the jobs and leave your individual ones and just add a second step for each one.

    I.E.

    Job1

    Step 1 - Do something

    Step 2 - sp_start_job("Job2")

    Job2

    Step 1 - Do something else

    Step 2 - sp_startjob("Job3)

    etc...

    You can also use sp_help_job to check the status of your jobs as well.



    Everything is awesome!