How to create proxy account

How to create SQL Server Agent proxy

A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step

You must create a credential before you create a proxy if one is not already available.

To create credential, Right click on Credentials

Give Credential Name – New Credential

Identity – Domain Name\Username (Windows username)

Password – Windows password

Confirm password and click OK.

So now credentials has been created

Now let’s create proxy account,

Right Click on Proxies and select New proxy

Give Proxy Name(as your choice)

Credential Name: select the credentials you just created your (Domain Name\Username)

From Active to the following subsystems

Selection options (SQL Server Integration service package) if you want to run package

Or Choose appropriate one based on your requirement. Click ok

Now if you want to run Agent job using proxy account, choose RUN AS proxy you created

see below image.