How to create Alert for long running jobs in all sqlservers

• M@hesh

  Old Hand

  Points: 375

  More actions

  July 3, 2012 at 4:56 am

  #258291

  Hi,

  Can you please provide the steps for Long running jobs script for all servers.

  Thanks in Advance.

• Dana Medley

  SSCertifiable

  Points: 6764

  More actions

  July 3, 2012 at 6:59 am

  #1508213

  I'm not sure if this is what you're looking for, but here are a couple of articles that might be of some assistance.

  http://www.databasejournal.com/features/mssql/article.php/3491201

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

  ---

  
  Everything is awesome!