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

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Right-click SQL Server Agent and select Properties. Click the Alert System page.

  3. Under Fail-safe operator, check Enable fail-safe operator. In the Operator list, click an operator.

  4. Click the appropriate notification types to specify how the operator will be notified.

See Also

Tasks

How to: Create an Operator (SQL Server Management Studio)

Help and Information

Getting SQL Server 2005 Assistance