Change Job's Owner
Go Up to Available object actions by DBMS
This action builds and submits an sp_update_job call with an @owner_login_name argument. It lets you change the owner of a SQL Agent job.
Platform Availability
To Change the Owner of a Job
- Initiate a Change job’s owner action against a job. For more information see Initiating an object operation.
- DBArtisan opens the Change job’s owner dialog.
- Use the following table as a guide to understanding and modifying settings in the Change job’s owner wizard:
Step | Settings and tasks | |
---|---|---|
Action Options |
From the New Owner dropdown, select the new owner for the job. | |
Preview |
Displays the DDL that will execute the object action. For details, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.