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.
The ability to trigger a response would be next level. It would allow for some automation of response.
It is still a great idea.
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
This would be a great feature.
Claudio Mendes commented
Great Idea! sadly I doesn't have any votes left so sorry for not upvoting.