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.

Note

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.

See Also

Concepts

Viewing and Modifying Jobs
Creating SQL Server Agent Proxies

Help and Information

Getting SQL Server 2005 Assistance