Trigger Self Healing Script and Auto Close
It would be great if SQL Monitor could invoke a SQL script upon an alert threshold being crossed and then take action within itself (ie. clear itself, notify a team, etc) based on the value returned (0/1) or default to an action if there is an issue with the script execution.
This type of functionality would help administrators have a first line of defense before truly getting paged on an alert such as a drive filling (perhaps you have txt files you can purge or shrink logs (though I don't necessarily condone this, but you get the idea!)
-
Michael Ansaldi commented
Another example of this type of functionality being helpful would be for failover scenarios (clustered or AG), being able to run a script which serves as a general health check (criteria defined by administrators) and then close the alert out based on a return code would be nice.