Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_start_job (Transact-SQL) Expand / Collapse
Author
Message
Posted Tuesday, October 12, 2010 12:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 16, 2014 10:44 AM
Points: 153, Visits: 583
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.
Post #1003124
Posted Tuesday, October 12, 2010 1:47 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 7, 2014 1:54 PM
Points: 450, Visits: 1,337
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
Post #1003185
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse