Alert triggering SELECT statement
Guldbrand
Posts: 3
Do you know if it is possible to trigger a SELECT statement when a alert is raised? I mean that when sending out the alert notification on email it would be nice to have some additional data from a SELECT attached to this notification.
In my concrete example I have an alert on a metric calculating the percentage of used space on the log files. If above 80 it raises an alert. To this alert I would like to SELECT the active transactions exactly when the alert is detected so it is possible to see if any long running transactions are filling up the log.
And if not possible would it be a feature to consider? I think it could be useful in many cases.
Thank you in advance!
In my concrete example I have an alert on a metric calculating the percentage of used space on the log files. If above 80 it raises an alert. To this alert I would like to SELECT the active transactions exactly when the alert is detected so it is possible to see if any long running transactions are filling up the log.
And if not possible would it be a feature to consider? I think it could be useful in many cases.
Thank you in advance!
Comments
This isn't possible at the moment, but I am sure that the development team would love to hear about it. Could I suggest that you post on the SQL Monitor UserVoice forum. The forum is used by the development team to gather these ideas and gauge other users interest in them.
https://sqlmonitor.uservoice.com/forums ... uggestions