December 9, 2011 at 10:24 am
I've tried about 12 different searches on Google now and have come up with nothing. I even tried MSDN and got all sorts or nighttime reading material but still can't find the possible return values for last_executed_step_id column in the msdb.dbo.sysjobactivity table
Does anyone know off ahnd what those are? I believe there are 7. 0 and 1 relate to whether or not the job is running or idle, I think 4 depicts a failure...but what are the others?
Any help would be greatly appreciated!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 9, 2011 at 1:30 pm
Wow, I can't believe took over 30 mins going through google (NOTHING came up on any microsoft sites..) but finally found this - in case anyone is interested:
http://www.sqllion.com/2011/11/job-running-status-report-in-ssrs/
0 - Completed /Not started
1 - Executing
2 - Waiting for thread
3 - Between retries
4 - Idle
5 - Suspended
7 - Performing Completion Actions
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply