Starting a job from another job

• Edward-445599

  Hall of Fame

  Points: 3147

  More actions

  February 5, 2009 at 5:15 am

  #127919

  Hi,

  I was wondering how you could start another job from with in another job.

  I have a long running job when it finishes I want it to kick of another job.

• Sakthivel Chidambaram

  SSCertifiable

  Points: 5531

  More actions

  February 5, 2009 at 5:30 am

  #938740

  EXEC msdb.dbo.sp_start_job @job_name = 'My SQL job'

  This code will do!

  Regards,
  Sakthi
  My Blog -> http://www.sqlserverdba.co.cc

• Edward-445599

  Hall of Fame

  Points: 3147

  More actions

  February 5, 2009 at 7:19 am

  #938824

  great many thanks