This topic has not yet been rated - Rate this topic

AlertSystem.FailSafeOperator Property

SQL Server 2008

Gets or sets the operator to notify when no other operator is defined or available on the alert notification.

Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

[SfcPropertyAttribute]
public string FailSafeOperator { get; set; }

Property Value

Type: System.String
A String value that specifies the fail-safe operator.

Remarks

The specified operator receives notifications when an alert does not have an operator assigned to receive a notification during the time that the alert was raised, or when an attempt to notify an assigned operator fails.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Reference

AlertSystem Class

AlertSystem Members

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automating Administrative Tasks (SQL Server Agent)

sp_add_alert (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD