I would like to alert, and report on, jobs that fail. But, only for jobs that are enabled. I have a whole listing of SQL jobs that the last time they were run they failed. So, the DBA just disabled them and doesn't want to delete them. Everytime I run a report on failed jobs they show up on the list even though the jobs were disabled months ago. The same with alerts. If I can't filter out the disabled, but previously failed, jobs the folks get alerts. Thanks!
