Monitoring SQL server severity alerts
HI all ,
Hope everyone is fine . Need a guidance how can we setup monitoring on SQL server severity alerts. These alerts we can configure in SSMS and then Sql server agent and then alerts.
...
Forum Discussion
If you haven't already found something in the Exchange, you're probably looking at building your own EventSource. I say EventSource because these appear to be alerts, not numerical data. So, you'd start by first asking how that data can be got at programmatically. Then you'd write a script to fetch that data. That script can be run natively with Groovy or you could use a different programming language. (Using a different programming language simply requires that that language's interpreter be available to the collector. The collector can't run a Python script if Python is not installed on the same server as the collector.)
I'm not a SQL guy, but SSMS seems like a message queue yeah? If so, can you script a way to get the stuff you want out of that message queue? That's your first hurdle.
