Support for regular expressions
Most of the alarms need more granular support for excluding/including different things. Using regular expression is a good idea and should be extended further. For example you defenitly need to be able to filter out things from the alarm on the sql server errorlog. Without it's useless.
Tom Horner, SQL production DBA commented
I was asked to add to this item. I asked support: Is there any way to configure the “job duration unusual” alert to ignore certain jobs? In my case, I would like to ignore the transaction log backups SQL Agent jobs. Another alert allows one to ignore certain jobs, the “long running query” alert. Is there a way to do this for “job duration unusual” alert? I hope this planned change covers regular expressions for "job duration unusual" alerts also. Sometimes you have jobs that run long or slow compared to the average, but this is expected behavior and an alert is not necessary.
This would save on numberouse unncecessary high errors, most needed.
Priya Sinha commented
Thanks a lot Michael for your feedback!