No Email Alert on Consecutive Failures

nileriver

Is there a way to get an email alert on consecutive failures? We have a SQL Server Agent Job that runs daily. When it fails for the first time, we get an email alert. We usually go in and try to fix the issue, but if it happens to fail the following day as well, we are not alerted via email.

Is there a way to turn this on?

Ben_P

Hi Neil,

Thank you for your post. 

For the SQL Server Agent job alert this will alert on the first time a job fails, it will not alert on subsequent failures though as this is a Continuous alert. So the alert will remain active until the job completes successfully again. If after completing successfully the job then fails, it will alert on this failure.

nileriver

Ben_P said:

Hi Neil,

Thank you for your post. 

For the SQL Server Agent job alert this will alert on the first time a job fails, it will not alert on subsequent failures though as this is a Continuous alert. So the alert will remain active until the job completes successfully again. If after completing successfully the job then fails, it will alert on this failure.

Is there any way to override this behavior?

Ben_P

I'm afraid there isn't a way to override this behaviour.