track the jobs that are running for more than one hour

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  May 6, 2008 at 12:03 pm

  #207113

  Hi,

  I want to track the jobs that are running for more than one hour. Any job which is executing from last one hour needs to send me an alert.

  Please tell me how it can be done in SQL Server 2000.

  Thanks in advance,

  Manu Jaidka

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  May 6, 2008 at 12:14 pm

  #811392

  MANU (5/6/2008)

  ---

  Hi,

  I want to track the jobs that are running for more than one hour. Any job which is executing from last one hour needs to send me an alert.

  Please tell me how it can be done in SQL Server 2000.

  Thanks in advance,

  Manu Jaidka

  http://www.sqlservercentral.com/articles/Administering/longrunningjobs/1897/

  http://www.sqlservercentral.com/articles/Administering/controllingunusuallylongrunningjobs/1858/

  also search for Long running jobs on SQLServerCentral site and you get a few very good articles.

  SQL DBA.