Introduction
Sometimes, you just need to run that SQL Server Job under another user account. Either because:
- You need the Job be run in another user’s context or
- You are getting ZappySys licensing error when running a Job with SSIS package created with SSIS PowerPack.
In both cases you need to use SQL Server Agent Proxy account. Below you will find how to create one and use it in a Job.
Steps
Create Credential in SQL Server
Start by creating a new Credential linked to user which has local administrator permissions:
Create SQL Server Agent Proxy in SQL Server
Then create a Proxy:
And configure it to run SSIS-type of Jobs:
Use Proxy in SQL Server Agent Job to run
Finally, select Proxy in your SQL Server Agent Job Step:
More info at Microsoft TechNet video.
Done! Time to enjoy some great coffee!