YOUR's SQL SERVER
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment