This post originated from an RSS feed registered with .NET Buzz by Steve Hebert. Original Post: Identifying long running Sql Server Agent Jobs article Feed Title: Steve Hebert's Development Blog Feed URL: /error.htm?aspxerrorpath=/blogs/steve.hebert/rss.aspx Feed Description: .Steve's .Blog - Including .Net, SQL Server, .Math and everything in between Latest .NET Buzz Posts Latest .NET Buzz Posts by Steve Hebert Latest Posts From Steve Hebert's Development Blog

Gregory Larson put together a nice code article on Database Journal on detecting long-running SQL jobs.  The code fires off an email to a designated contact when a job is running for more than 6 hours.  I could personally see a use for logging instances of a job running for more than, say, 60 minutes to a table. His code is certainly easy enough to modify.