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.

NoteNote

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.

To give others ownership of a job

  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.

Community Additions

ADD
Show:
© 2014 Microsoft