I have a business application that leverage SSIS jobs running under the SQL Server Agent. They have over 500 jobs setup to do remote work on SQL servers from 1 central SQL box.

SInce there are so many jobs, I need to be able to setup a monitor that handles different jobs accordingly. Say APP1 sends to APP1 Team, but because APP2 jobs are configured, I want to be able setup monitoring APP1*, APP2*, etc.

Very similar to the functionality that Alain put in the NT_ServiceDown to monitor WILDCARD services.

It would be nice if the SQLServer_MonitorJobs had this flexability?

by: Phil S. | over a year ago | AM Windows Modules