When you need to execute job steps under a specific security context, proxy account can be used to allow users who are not sysadmin to run them.
Before you can create a proxy account, you first need to create a credential that needs to be linked later. This can be a window service account or a user’s active directory id.
Creating a Credential
- In the Object Explorer, expand Security node
- Right-click Credentials node and select New Credential
- After giving a name to the credential, enter a Windows account and the password
Creating a Proxy
- Back in the Object Explorer, expand the SQL Server Agent node
- Right-click Proxies and select New Proxy Account
- You can use the same proxy name as your credential
- Select any subsystems you want to enable for the particular proxy
In this example the proxy was created to run SSIS packages, so SQL Server Integration Services Package was checked. That’s all there is to it.
More detailed information can be read from “SQL Server Agent Proxy Account” section from the following book:
SQL Server 2016 High Availability Unleashed