SQL Server agent & job dependencies

• Rafael A. Colón

  Right there with Babe

  Points: 721

  More actions

  January 21, 2005 at 2:30 pm

  #86601

  Does anybody knows if SQL Server agent can perform job dependencies, for example do not start Job B unless job A completes successfully or the job finished (sucessfully or not)

  I'm trying to do something like that , but I'm not sure if that is possible with SQL server agent. Using SQL server 2K SP4

   

  Thank you 

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  January 21, 2005 at 3:09 pm

  #538611

  You can do this by making the second job start as a job step in the first. For instance, calling sp_start_job from the first job itself.

  K. Brian Kelley
  @kbriankelley