sp_start_job (Transact-SQL)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » sp_start_job (Transact-SQL)

sp_start_job (Transact-SQL)

Rate Topic

Display Mode

Topic Options

Author

Message

Ranzz

Posted Tuesday, October 12, 2010 12:37 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:42 PM
Points: 138, Visits: 510

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

Leo.Miller

Posted Tuesday, October 12, 2010 1:47 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 442, Visits: 1,302

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 »

Permissions