Run Multiple SQL jobs

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  November 21, 2008 at 12:01 pm

  #383437

  How can i run a sql job inside a sql job.

  I have a 2 jobs where it alters a same huge table, i want to shedule both as i cudnt predict time when a job will be finished how can i start a 2nd job after finising the 1st one. since they are altering same table and if i shedule job what if both jobs starts altering same table at the same time.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  November 21, 2008 at 4:24 pm

  #901922

  Invoke the second job on completion of first job by calling it under second step by making use of sp_start_job stored procedure.

  http://technet.microsoft.com/en-us/library/ms186757(SQL.90).aspx

  HTH,

  MJ