Monitoring SQL server severity alerts

22 minutes ago, Stuart Weenig said:

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.

Hi Stuart thanks for your reply . SSMS is SQL server managment Studio . These alerts can be create using this or you can use the store procedure. You can put the Error number here and then enabler the alert .  I'll try above option . More suggestion are welcome :)/emoticons/smile@2x.png 2x" title=":)" width="20" />