March 12, 2013 at 12:50 pm
Trying to set up alerts and/or email notifications in SCOM 2007 that are triggered by SQL Server (2005 & 08) severity levels 19-25 and 823–825. Several db servers at my organization cannot send dbmail due to compliancy issues so I need another way to send alerts.
Does anyone know if this can be accomplished in SCOM 2007? I can only find SCOM severity levels 0, 1, and 2 in FMSQLOPERATIONS.alert.vAlert. Maybe I can log these or pull these from the SQL Boxes' windows app logs using SCOM.
Anybody have any experience with this?
March 26, 2013 at 9:00 am
Guess I'll try setting up the SQL severity alerts to kick off a SQL job. Then have that SQL job write to the application log.
I should then be able to pull in the events from the SQL server's application log into SCOM 2007. SCOM will then email me the alerts. SCOM has access to send mail, but the SQL boxes do not.
Anyone know of an easier way to accomplish this?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply