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
Execute sp_add_operator to specify the master SQL Server Agent operator.
Execute sp_add_targetsvrgrp_member to add the specified target server to the target server group.
Execute sp_msx_enlist to enlist the target server in the job.
Execute the steps in How to: Create a SQL Server Agent Master Job (Transact-SQL) to create a master SQL Server Agent job.
See Also
Concepts
Other Resources
System Stored Procedures (Transact-SQL)
sp_add_operator (Transact-SQL)
sp_add_targetsvrgrp_member (Transact-SQL)
sp_msx_enlist (Transact-SQL)