Job step failure - trigger an alert, even if the job itself doesn't fail
CONTEXT: If job step "On failure action" is set to "Go to next step" or "Go to step xy...." and the step fails, we would like to be alerted. The alert should be triggered immediately (as opposed to at the end of the job).
PROBLEM: SQL Monitor "Job failed" alert doesn't alert in such cases.
EXAMPLE SOLUTIONS:
• A new alert.
• Expanding options on the "Job failed" alert.
Blaž Dakskobler
shared this idea
As of version 13.0.55 (February 27, 2024).
Job failing alerts can now be raised when any individual job step fails, even if the overall job succeeds.
-
Blaž Dakskobler
commented
@Redgate: what's the status for this suggestion?
Consider also that some votes on https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2936478-identifiy-the-failed-job-steps-when-a-job-has-fail were actually meant for this particular case, as seen from the comments there. -
E Scallin
commented
I agree with this suggestion. I don't even understand how it's not implemented yet. One of the reasons I purchased SQL Monitor is so I don't have to look at my logs every day. Because of this lack of functionality, I still have to review my Agent logs every day to check for failed steps..
In short, an alert should be raised whenever any step in a job fails, even if the job does not.