Hi,

I am trying to write a query on the jobs system tables to show me all jobs that are currently running for too long a time, over a certain duration limit. I have looked at the system tables and the sp_help_job stored procedure but I can't quite see how to do it.

Thanks for any help,

Diane Davis


MS Sql Server LazyDBA home page