sp_start_job (Transact-SQL)

• anzz

  SSCertifiable

  Points: 5503

  More actions

  October 12, 2010 at 12:37 pm

  #227829

  USE msdb ;

  GO

  EXEC dbo.sp_start_job N'Weekly Sales Data Backup' ;

  GO

  The syntax is for kick off the single job when one job is done.

  now my question is?

  what is syntax for adding for two or more job kick off at time. I mean adding one more job and should run parallely.

  Thanks in Advance.

• Leo.Miller

  SSChampion

  Points: 13048

  More actions

  October 12, 2010 at 1:47 pm

  #1235845

  Sorry but the sp_start_job stored proc only accepts a single job name.

  try:

  EXEC dbo.sp_start_job N'Weekly Sales Data Backup' ;

  go

  EXEC dbo.sp_start_job N'Next Database Data Backup' ;

  go

  Alternately you could just schedule the jobs, thats what the scheduler is there for.

  Cheers

  Leo

  Leo
  Nothing in life is ever so complicated that with a little work it can't be made more complicated.