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.


object.FailSafeOperator [=value]


  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A string that identifies an existing Microsoft SQL Server operator

Data Type




Prototype (C/C++)

HRESULT GetFailSafeOperator(SQLDMO_LPBSTR pRetVal);
HRESULT SetFailSafeOperator(SQLDMO_LPCSTR NewValue);


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.


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.

Applies To: