Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)