where can I find the current job status in the msdb tables?

[aolb]

I want to write a query that returns if a specified job is currently running. I expect to find this data in the msdb.dbo.sysjobs or msdb.dbo.sysjobhistory tables but nothing jumps out as the field I want.

Can someone tell me what field and table I need to return the current job status?

Thanks

 

[mutley1]

Hey aolb,

My turn to help you (possibly)! Have a look at this link - it is for long running jobs set to check if something has been running for 6 hours or more but can be adapted to see exactly what is running and how long it has been running.

Long Running Job

Cheers,

M.

 

[aolb]

thanks mutley1... not straight forward as the is come converting from hex to char to do in the solution. will give it a go