Hi,
Wanted to know if there is a way to change the alert to be every hour or time frame and not on each failure.
for example this is the alert we have today:
The job ran 2 minutes and failed. so we get this alert:
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.
We want something like :
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 10:30:00 PM.