Is there a way to change the alert for an alarm in Spotlight to be every hour, or a certain time frame, and not on each failure?
For example:
The job ran 2 minutes and failed, and the alert appears: 'SQL Agent - Jobs Failed: The SQL Agent Job '###' failed 1 time between Wednesday, March 24, 2021 7:30:00 PM and Wednesday, March 24, 2021 7:32:11 PM'.
Can this be shown as: 'SQL Agent - Jobs Failed: The SQL Agent Job '###' failed 7 times between Wednesday, March 24, 2021 7:30:00 PM and Wednesday, March 24, 2021 8:30:00 PM'?
Could it run every hour, saying which jobs failed and how many?
