
Explanation/Reference:
Explanation:
Step 1: Create a credential that uses CONTOSO \JobProcess1
You must create a credential before you create a proxy if one is not already available.
Step 2: Create a proxy account.
Step 3: Modify the SQL Server Agent job step to use.
To automate package execution by using SQL Server Agent
...
To create a job step for the package you want to schedule, click Steps, and then click New.
Select Integration Services Package for the job step type.
In the Run as list, select SQL Server Agent Service Account or select a proxy account that has the credentials that the job step will use.
Using a proxy account instead of the SQL Server Agent Service Account may resolve common issues that can occur when executing a package using the SQL Server Agent.
References:
https://docs.microsoft.com/en-us/sql/integration-services/packages/sql-server-agent-jobs-for-packages
https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-proxy