Modifying and Viewing Operators
Because operators are individuals with changing responsibilities and job schedules, you may need to update operator information. After an operator has been created, you can:
- View an operator's information.
You can view the alerts for which the operator is responsible. You can view the dates of the most recent attempts by SQL Server Agent to notify the operator.
- Edit an operator's information.
You can edit the notification addresses, pager on-duty schedule, assigned alerts, and notification methods.
- Change an operator's availability.
By default, operators are available to receive notifications (enabled) as soon as they are defined. You can specify the operator as unavailable to receive notifications (disabled) when you create it or at any time thereafter.
For example, if an individual who is assigned operator responsibilities goes on vacation, you can disable the operator. The alerts assigned to that operator and the notification methods for those alerts have not changed; only the operator's availability to respond to alerts has been changed. When the individual returns from vacation, you do not need to redefine the operator; rather, you reenable the operator.
- Delete an operator.
You can delete an operator when the individual no longer has operator responsibilities. When you delete an operator, you also delete all of the operator's alert notifications. You cannot remove an operator that has been assigned to be the fail-safe operator. You first must remove the fail-safe duty from the operator or reassign the fail-safe duty to another operator before you can delete the operator.
To view information about an operator
Transact-SQLTo edit an operator
To change an operator's availability
To delete an operator