Andy,

We periodically will see stopped jobs both ad-hoc and monitoring policy. I noticed there are some queries to find stopped jobs within the QDB, but I'm wondering if there is a query that can be used to pull in the number of stopped jobs per management group? NQCCDB. I would like to run a daily query SQLServer_RunCmdin the morning that could tell me how many monitoring policy jobs and ad-hoc jobs outside of discovery jobs were stopped?


When you have over 4K servers to monitor this could be fairly big, and as you know it is sometimes tough to pinpoint why a job may have stopped?

Phil