var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Status Field In Management - Jobs
I am trying get the status field from the list of jobs in management. I have a activex script that queries system tables to find out if a job has failed and sends the report via e-mail.
Currently I use this query to get the names of jobs failed...
FROM msdb.dbo.sysjobs A, msdb.dbo.sysjobservers B WHERE A.job_id = B.job_id AND B.last_run_outcome = 0
ORDER BY name
I need to add some criteria around the status field to get the appropriate results.
I think you want to take a look at the current_execution_status column returned by this proc:
see BOL for what the values mean: http://msdn2.microsoft.com/en-us/library/ms186722.aspx