Alert triggering SELECT statement

GuldbrandGuldbrand Posts: 3
edited February 26, 2015 2:37AM in SQL Monitor Previous Versions
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!


Sign In or Register to comment.