Alert For long Running Jobs

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  July 28, 2010 at 7:14 am

  #141243

  Hi !

  I am new to DBA tech. can some one guide me in generating the alerts for long Running Jobs in Step by step in more detail.

  Thanks in advance 🙂

• gk-411903

  Hall of Fame

  Points: 3801

  More actions

  July 28, 2010 at 10:21 am

  #1199345

  Long running jobs : http://www.sqlservercentral.com/articles/Administration/longrunningjobs/1897/

  Identifying Long running SQL Server Agent jobs : http://www.databasejournal.com/features/mssql/article.php/3500276/Identifying-Long-Running-SQL-Server-Agent-Jobs.htm

  Track long running queries :

  http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30908/