Defining Operators

The primary attributes of an operator are name and contact information. It is recommended that you define operators before you define alerts. You must set up one or more of these to notify an operator:

Naming an Operator

Every operator must have a name. Operator names must be unique and can be no longer than 128 characters.

Providing Contact Information

An operator’s contact information defines how the operator is notified. Operators can be notified by e-mail, pager, or net send:

If all of the operators share a pager provider, you can use SQL Server Enterprise Manager to specify any special e-mail formatting required by the pager-to-e-mail system. The special formatting can be a prefix or a suffix:


Note If you are using a low-capacity alphanumeric paging system (for example, limited to 64 characters per page), you can shorten the text sent by excluding the error text from the pager notification.


Designating a Fail-Safe Operator

The fail-safe operator is notified about an alert after all pager notifications to the designated operators have failed. For example, if you have defined three operators for pager notifications and none of the designated operators can be paged, the fail-safe operator is notified.

The fail-safe operator is notified when:

Because the fail-safe operator is a safety feature, you cannot delete the operator assigned to fail-safe duty. You must reassign fail-safe duty to another operator or delete the fail-safe assignment before you can delete the operator assigned to fail-safe duty.

To create an operator

         

To assign alerts to an operator

         

To format pager addresses

    

To designate a fail-safe operator

    

See Also
sp_help_operator sp_add_operator
Operator Object AddNotification Method
AlertSystem Object sp_help_notification
sp_add_alert  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.