Export (0) Print
Expand All
Expand Minimize

How to: Give Others Ownership of a Job (SQL Server Management Studio)

This topic describes how to reassign ownership of Microsoft SQL Server Agent jobs to another user. Only members of the sysadmin fixed server role can change job ownership.

If you change job ownership to a user who is not a member of the sysadmin fixed server role, and the job is executing job steps that require proxy accounts (for example, SSIS package execution), make sure that the user has access to that proxy account or else the job will fail.

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent, expand Jobs, right-click the job, and then click Properties.

  3. In the Owner list, select a login. You must be a system administrator to change the owner of a job.

    Assigning a job to another login does not guarantee that the new owner has sufficient permission to run the job successfully.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft