How to create an operator (Transact-SQL)

To create an operator for a local job

To create an operator for a master SQL Server Agent

  1. Execute sp_add_operator to specify the master SQL Server Agent operator.
  2. Execute sp_add_targetsvrgrp_member to add the specified target server to the target server group
  3. Execute sp_msx_enlist to enlist the target server in the job.
  4. Execute the steps in How to create a master SQL Server Agent job (Transact-SQL) to create a master SQL Server Agent job.
See Also
Defining Operators System Stored Procedures (SQL Server Agent)

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.