Alert will not re-trigger after 1 alert per morning.
The main issue I am having is I have an alert set up to run each hour but it will only actually alert once per day. I think the root of the issue is that the alert is being created and places in “Active” status instead of being created in “Ended” status. I feel like an alert will not retrigger if the alert is still active on a specific server being monitored. To provide a little background information on the alert, the alert is looking for any value over zero from a T-SQL standpoint. I think we have that set properly in the threshold section below. Additionally, we have the Frequency set to 1 hour. In this case I would expect 24 alerts per day(1 each hour) if the issue is not resolved. At the moment we seem to be getting 1 alert for each database server around Midnight each day. This makes me feel I have some sort of setting to only allow 1 alert per day or per server until the alert is “ended” for the specific database. I’m sure there is some small setting I might be missing.
Does anyone have an idea of why this might be happening?
Frequency: 1 hour
Threshold : 0
Alerts: Created the first time each day.