Be able to run a query (or powershell) in response to an alert
Be able to run a query (or powershell) in response to an alert.
This would automate some responses, but also want to be able to send the RESULT of a script in the email that goes out, ie Alert to say Schema changes have been made where the email actually includes the schema changes.
11
votes
Robi Detwiler
shared this idea
-
Hans van Dam
commented
This would be a great enhancement, taking SQL Monitor to a higher level (not just Monitoring).
However, you can incorporate fixes in the Metrics query in some cases, or create separate Metrics for them. It's kind of abuse because it wasnt meant to use like that, but you can...