Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)