Hi Rudy & Everyone,
Nice solution Rudy. But just to throw an angle, I have resisted taking this approach for some time. I have my reasons:
I have about 30 servers/instances. A few of them have as many as 60 jobs. The way I monitor them is that every job sends me (and other personnel as needed) an email, but only if it fails. This method has served me perfectly for almost 10 years. I haven't seen any holes in my approach, but maybe some of you can?
Thanks!
Uncle Ben