Run a custom SQL script when an alert is raised
We use SQL monitor very heavily for our SQL and application monitoring, what we would like is for each alert to be able to define a custom sql script to run when the alert is raised, the output of this sql should be included in the alert.
This would allow us to do things like capture whoisactive when blocking occurs or other application specific things and make responding to alerts MUCH easier.
Jason
shared this idea
-
Carlos
commented
The ability to trigger a response would be next level. It would allow for some automation of response.
-
Anonymous
commented
It is still a great idea.
-
Anonymous
commented
This is a much needed feature! SNMP traps are horrible and require another monitoring system, running a script it would allow you to integrate with any rest api or database
-
alexsdba
commented
This would be a great feature.
-
Claudio Mendes
commented
Great Idea! sadly I doesn't have any votes left so sorry for not upvoting.