jobs execution monitoring

• federico.hauske

  Grasshopper

  Points: 15

  More actions

  April 22, 2013 at 2:35 pm

  #274193

  Hi

  I wonder if there is an article about monitoring jobs, something similar to backups recent article script, we have several jobs running on each sql server, need o get the status of all jobs in a single monitoring server.

  Regards.

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  April 22, 2013 at 2:41 pm

  #1608861

  Hi,

  Loads of articles on this, here's a starting point:-

  http://www.mssqltips.com/sqlservertip/2717/monitoring-jobs-on-multiple-servers-by-using-multi-server-query/

  Andrew

• writearjun53

  Ten Centuries

  Points: 1060

  More actions

  April 23, 2013 at 12:46 am

  #1608950

  For monitoring the sql sqlserver,you can uses below procedure.

  EXEC sp_who

  EXEC sp_Who2

  Regards,

  Arjun.