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)
(c) 1988-98 Microsoft Corporation. All Rights Reserved.
To modify a local operator
To modify a local operator
To modify an operator for a master SQL Server Agent