Add exclusions to Job Failing alerts
When a user deliberately stops a job while it's running, it fires a job failed alert. Add exclusion regex so we can add something like "The job was stopped prior to completion by User...." to ignore these.
SLowry
shared this idea
-
ptrubs
commented
This exclusion would require a regex to be compared against the output Message of the job, rather than the job name itself?
It would be a bit simpler (and be of much greater utility to a wider audience) to allow the exclusion based on regex of the job name. Similar to the what you can exclude of the Job Duration Unusual alert
After a bit more searching, this _specific_ issue has been addressed in Version 9.0.13 released 23rd May (https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/37287307-sql-agent-jobs-with-a-cancelled-status-are-incor)
-
Scott
commented
Similar to this, I'd like to exclude certain jobs from the alert. We have some that run every few minutes. If it fails once and succeeds the next time, it's not an issue.