How to: Designate a Fail-Safe Operator (SQL Server Management Studio)
This topic describes how to set a fail-safe operator to receive Microsoft SQL Server Agent alert notifications. A fail-safe operator is a user who receives the alert if the designated operator cannot be reached.
To designate a fail-safe operator
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
Right-click SQL Server Agent and select Properties. Click the Alert Systempage.
Under Fail-safe operator, check Enable fail-safe operator. In the Operator list, click an operator.
Click the appropriate notification types to specify how the operator will be notified.