Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.