Change Job's Owner

From DBArtisan
Jump to: navigation, search

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

  1. 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.
  2. 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.