Alert when no witness

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Alert when no witness

Alert when no witness

Rate Topic

Display Mode

Topic Options

Author

Message

Jorge Escobedo

Posted Wednesday, April 02, 2008 4:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 05, 2009 11:49 AM
Points: 1, Visits: 13

Hi all, I created an alert to send an e-mail where Witness is no present on my Mirroring Configuration, but it is not firing the alert when I disconnect the Witness.

USE [msdb]
GO
/****** Object: Alert [Sin Witness] Script Date: 04/02/2008 15:15:16 ******/
EXEC msdb.dbo.sp_add_alert @name=N'Sin Witness',
@message_id=0,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER',
@wmi_query=N'SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE where state=10',
@job_id=N'00000000-0000-0000-0000-000000000000'

Could someone tell me what is wrong?

Thank you

Post #478894

« Prev Topic | Next Topic »

Permissions