FailSafeOperator Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The FailSafeOperator property specifies an operator to notify when no other operator is defined or available on SQL Server Agent alert notification.
Syntax
object.FailSafeOperator [=value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
A string that identifies an existing Microsoft SQL Server operator
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFailSafeOperator(SQLDMO_LPBSTR pRetVal);
HRESULT SetFailSafeOperator(SQLDMO_LPCSTR NewValue);
Note
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.
Remarks
The FailSafeOperator property 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 failed.