Typically when a continuous alert is triggered, I get a Raised email, then sometimes an Escalated email after a minute or two, then once the problem is no longer occurring, there will be an Ended email.
However, sometimes when an alert goes to Escalated, I never get the Ended email. I think this may be due to the context ending before the Escalated email is sent, because the ended condition is shown in the body of the request email.
Here's an example from today - same SQL instance and same alert type (instance unreachable)
1a) Raised
1b) Escalated
1c) Ended
2a) Raised
2b) Escalated
I never received an Ended message for 21183107 (and no, it hasn't gotten slightly delayed on the way; it's been 4 hours). The alert history shows that the alert changed to Ended and shows a Time Ended timestamp as expected, but the email notification never showed up.
I speculate that this is related to the fact that the “instance became reachable again” is a part of the body of the Escalated email. Maybe that's due to the fact that it became reachable again and was escalated within the same minute (11:26)? Maybe it became reachable as the Escalated email was being built? In case 1, these events occurred in different minutes (escalated 11:10, reachable 11:12)
This is a problem for our alerting software as it is configured to look for Ended emails to know that a problem is no longer active.
I am using Redgate Monitor version 14.0.77.25071.
Typically when a continuous alert is triggered, I get a Raised email, then sometimes an Escalated email after a minute or two, then once the problem is no longer occurring, there will be an Ended email.
However, sometimes when an alert goes to Escalated, I never get the Ended email. I think this may be due to the context ending before the Escalated email is sent, because the ended condition is shown in the body of the request email.
Here's an example from today - same SQL instance and same alert type (instance unreachable)
1a) Raised
1b) Escalated
1c) Ended
2a) Raised
2b) Escalated
I never received an Ended message for 21183107 (and no, it hasn't gotten slightly delayed on the way; it's been 4 hours). The alert history shows that the alert changed to Ended and shows a Time Ended timestamp as expected, but the email notification never showed up.
I speculate that this is related to the fact that the “instance became reachable again” is a part of the body of the Escalated email. Maybe that's due to the fact that it became reachable again and was escalated within the same minute (11:26)? Maybe it became reachable as the Escalated email was being built? In case 1, these events occurred in different minutes (escalated 11:10, reachable 11:12)
This is a problem for our alerting software as it is configured to look for Ended emails to know that a problem is no longer active.
I am using Redgate Monitor version 14.0.77.25071.