Tuesday, August 23, 2011

Start and Stop the jobs by using T-SQL Query

Start

EXEC MSDB.dbo.sp_start_job @Job_Name = 'JobName'


Stop

EXEC MSDB.dbo.sp_stop_job @Job_Name = 'JobName'

No comments:

Post a Comment