This project is read-only.

Monitor jobs activity SQL server

Topics: Developer Forum, User Forum
Aug 17, 2007 at 9:42 AM

Every morning, I would like to know by server SQL, if the jobs are OK or not, Have a solution…

Thank you.
Aug 17, 2007 at 1:19 PM
I will be posting such a solution to the Samples page.
The idea is basically to use the system tables to determine this information and then using a SQL Monitor instance to run the sp that determines this information. However, current solution is for SQL 2000 only. Since system table names have changed, I need to convert the sp to SQL 2005 prior to posting. I will post sometime next week.
Aug 23, 2007 at 1:10 PM
A sample solution using PolyMon's SQL Monitor has been posted here: Sample Solutions

Aug 23, 2007 at 6:36 PM


I look this sample...