How to create an operator (Transact-SQL)
To create an operator for a local job
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 master SQL Server Agent job (Transact-SQL) to create a master SQL Server Agent job.
See Also
(c) 1988-98 Microsoft Corporation. All Rights Reserved.