Saturday, October 15, 2011

Tips: How to configure a Fail-Safe Operator

If anything goes wrong in SQL Server notifications, the operators will not be notified. Therefore, the problems will not be corrected in a timely manner. However as a precaution, you can designate a fail-safe operator. It will be notified if an SQL Server Agent can’t access the system table in the MSDB database (which is where operator definitions and notification lists are stored) when all the pager notifications to designated operators are failed or when the designated operators are off duty (as defined in the pager schedule).
How to configure a fail-safe operator?

1.    First, right click on the SQL Server Agent entry in the SQL Server Management Studio to select Properties.
2.    Now, it is required to select the Alert System page from the Properties dialog box.
3.    After that, it is required to select the Enable Fail-Safe Operator check box.

4.    Then, you can use the Operator list to select an operator to designate as the fail-safe operator. Moreover, you can re-assign the fail-safe duty by selecting a different operator or you can disable the feature by clearing the Enable Fail-Safe Operator check box.
5.    After that, use the Notify Using check boxes to determine how the fail-safe operator is notified.
6.    Then, click OK.

E-mail and Net Send messages almost always reach their destination—but the people involved are not always watching their e-mail or sitting at their computer to receive Net Send messages, so the fail-safe operator is a way to guarantee notification. Although the fail-safe operator for pager notification failure might seem strange, it is a good way to ensure that alerts are handled efficiently.

B  y ,