January 15, 2010 at 11:48 am
I'm trying to document our sql server jobs and I've found that running queries against msdb is really saving me a lot of time. I need to know what table I can join to to get the descriptions for the integer values held in the sysjobsteps.on_success_action and sysjobsteps.on_failure_action fields. Any help would be greatly appreciated.
January 15, 2010 at 12:03 pm
Most of the values you find in a MSDB table can be found in BOL: http://tinyurl.com/yc2crxx
Otherwise here they are for on_success_action, same applies for on_fail_action
1 = Quit the job reporting success.
2 = Quit the job reporting failure.
3 = Go to the next step.
4 = Go to step.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply