Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using WMI alert for mirroring in Sql server 2012 Expand / Collapse
Author
Message
Posted Tuesday, September 3, 2013 1:28 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 13, 2014 3:33 PM
Points: 179, Visits: 726

We are using mirroring in Sql Server 2012 and we are using WMI alerts for some of events such as Connection lost,Manual failover,...

In alert definition we have set the followings:

Type: WMI event alert

NameSpace: \\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER

Query: select * from DATABASE_MIRRORING_STATE_CHANGE where State = 6

The alert is bing triggered correctly,but on email description instead of having meaningful explaination like 'Connection lost',We have the same query:

Query: select * from DATABASE_MIRRORING_STATE_CHANGE where State = 6

We have used the same implementation in our Sql Server 2008 servers and it is working fine.This mashine (Sql Server 2012) is a new mashine.

I would appreciate if someone help me on this.AlsoI checked and 'Include body of e-mail in notification message' was already set.

Thanks

Aspet
Post #1491075
Posted Friday, January 3, 2014 2:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 4:07 AM
Points: 29, Visits: 232
The alerts are slightly different in 2012, if you right click your alert, go to properties and then Options you are presented with a free text field to add any "Additional notification message to send" and whether to include the additional text in email, pager or net send notifications.
Hope this helps!
Tony
Post #1527392
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse