--How to create  SQL Server Mirroring State Change messages
EXEC
msdb.dbo.sp_add_category
   
@class=N'ALERT',
   
@type=N'NONE',
   
@name=N'Mirror' ;
EXEC
msdb.dbo.sp_add_alert 
      
@name=N'DB
Mirroring: State Changes', 
      
@category_name=N'Mirror', 
      
@wmi_namespace=
      
N'\\.\root\Microsoft\SqlServer\ServerEvents\instancename', 
      
@wmi_query=N'SELECT *
from DATABASE_MIRRORING_STATE_CHANGE',
      
@enabled=1
 
Keine Kommentare:
Kommentar veröffentlichen