How to create an operator (Transact-SQL)

How to create an operator (Transact-SQL)

To create an operator for a local job

• Execute sp_add_operator.

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 Procedures)