InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 00:35:51 GMT20http://www.sqlservercentral.com/Forums/Topic1003124-146-1.aspxSorry but the sp_start_job stored proc only accepts a single job name.try:EXEC dbo.sp_start_job N'Weekly Sales Data Backup' ;goEXEC dbo.sp_start_job N'Next Database Data Backup' ;goAlternately you could just schedule the jobs, thats what the scheduler is there for.CheersLeoTue, 12 Oct 2010 13:47:39 GMTLeo.Millerhttp://www.sqlservercentral.com/Forums/Topic1003124-146-1.aspxUSE msdb ;GOEXEC dbo.sp_start_job N'Weekly Sales Data Backup' ;GOThe 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.Tue, 12 Oct 2010 12:37:14 GMTRanzz