No Email Alert on Consecutive Failures

• 

  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.

  Ben_P October 30, 2023 20:31

  - 0 +
• 

  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?

  nileriver October 30, 2023 20:46

  - 0 +
• 
  I'm afraid there isn't a way to override this behaviour.

  Ben_P November 14, 2023 16:09

  - 0 +

Add comment

Please sign in to leave a comment.