Time range for alerts

RhysRhys Posts: 35
edited February 18, 2011 5:03AM in SQL Monitor Previous Versions

It would be useful if we could configure alert rules to only apply to certain time ranges.

For example, On one of our server we do log backups on the hours, every hour apart from 5AM where a full backup occurs. I have configured the rule to alert us if there is no log backup for 1 hour. This is fine in general but alerts are raised (as you would expect) for the 5AM period where no log backup occurs. I could change the rule to 2 hours but then I wouldn't get alerts as quickly.

I could also see the benefit of this for other rules, i.e. long runnign query - could exclude time ranges where maintenance / reindexing occurs.




Sign In or Register to comment.