Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ruchirj07
Starting Member
37 Posts |
 Posted - 2007-10-08 : 08:13:41
|
| Hi,How can we find the status of a job?Also, is it possible to change the status of the job manually in a stored procedure?For eg. -When some error occurs in the stored procedure, job goes into RETRY mode rather than in cancel mode. I want to update the status from retry to cancel mode..is this possible?Ruchir |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-10-08 : 10:18:01
|
do you mean an agent job? you can change the status indirectly, but not directly.for example if you started the job, the status would change from "not running" to "running".you can check status by calling exec msdb.dbo.sp_help_job and looking at the current_execution_status column. values in this column are explained in BOL.
elsasoft.org |
 |
|
|
|
|
|
Status Code of a Job