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
- 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
Modifying and Viewing Operators
System Stored Procedures (SQL Server Agent Procedures)