Return
-
Title
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? -
Description
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?
-
Resolution
This is not possible with Spotlight Cloud. It can be achieved outside of Spotlight e.g. when you call a PowerShell script which will manage every alarm (and e.g. sending the summary) instead of sending every alarm to email directly.