Scheduling a job within a job

Question

Scheduling a job within a job

B Baer

SSC Enthusiast

Points: 146
More actions
June 15, 2004 at 8:55 am

#111564

Can a job schedule another job within sqlserver? I know I can add multiple steps and have multiple DTS packages within the job, but I am trying to avoid having many steps within one job and categorize certain jobs. Thanks.

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

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

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

You could run an sp_startjob as a TSQL step within the DTS, however it's not going to wait until the other job has completed before it goes on to the next step.

Shamless self promotion - read my blog http://sirsql.net

hoo-t SSChampion Points: 12713 More actions · Answer 2

Script the job (right click, all tasks, generate sql script), then pull the code out that creates the schedule. Insert that code into your job. Use sp_add_jobschedule to add a new schedule or sp_update_jobschedule to change an existing schedule. BOL has documentation for the 2 procedures.

Steve

stevevincent SSC Veteran Points: 265 More actions · Answer 3

Even simpler - take Nicholas' suggestion (sp_start_job) and insert it into your scheduled job, ie, NOT your DTS package. You will then have a step dependency. Your first job needs to complete its job steps before it reached your newly inserted final job step (unless you choose otherwise).

Steve

B Baer SSC Enthusiast Points: 146 More actions · Answer 4

Thanks for the suggestions. I tried Steve's suggestion and it works great!