How to modify an operator (Transact-SQL)

To modify a local operator

• Execute sp_update_operator.

To modify an operator for a master SQL Server Agent

1. Execute sp_msx_defect to remove the target server from the master SQL Server Agent.
   
   
2. Execute sp_update_operator to change the operator.

See Also

Modifying and Viewing Operators

System Stored Procedures (SQL Server Agent Procedures)