How to: Create Operators (Transact-SQL)

This topic lists the steps required to create a Microsoft SQL Server Agent operator for local jobs or for master server jobs by using stored procedures.

  1. Execute sp_add_operator.

  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 SQL Server Agent Master Job (Transact-SQL) to create a master SQL Server Agent job.

Community Additions