Thursday, 26 September 2013

How to start failed job manually

How to start failed job manually


/* Begin Query */

USE msdb
EXEC sp_stop_job @job_name = my job'
waitfor delay '00:00:05'

EXEC sp_start_job @job_name = 'my job'

/* End Query */


No comments: