Export (0) Print
Expand All

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

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft