How to: Modify Operators (Transact-SQL)
This topic describes how to modify a Microsoft SQL Server operator using stored procedures.
To modify a local operator
- Execute sp_update_operator.
To modify an operator for a master SQL Server Agent
Execute sp_msx_defect to remove the target server from the master SQL Server Agent.
Execute sp_update_operator to change the operator.
See Also
Concepts
Viewing and Modifying Operators
Other Resources
System Stored Procedures (Transact-SQL)
sp_update_operator (Transact-SQL)
sp_msx_defect (Transact-SQL)