In order to be able to do this you must perform the following actions within the instance of SQL Server:
- Create a credential
- Create a Proxy Account that uses the credential you created in the first step
You can then create the credential by providing an identity (i.e. a domain user) along with its password.
For creating a Proxy Account, in SSMS you navigate to: SQL Server Agent -- ProxiesYou can then create a new Proxy Account by giving it a name and performing the following:
- Provide the credential you earlier created
- Enter a description (optional)
- Set the subsystems for which the Proxy Account will be active. These are:
------- ActiveX Script
------- Operating system (CmdExec)
------- Replication Distributor
------- Replication Merge
------- Replication Queue Reader
------- Replication Snapshot
------- Replication Transaction-Log Reader
------- SQL Server Analysis Services Command
------- SQL Server Analysis Services Query
------- SQL Server Integration Services Package
That's it!You can now proceed and set up the SQL Server Agent job along with its steps, and in the step you want to use the Proxy Account you select it in the "Run as" drop down box.
Whenever the specific job step runs, it will be executed in the context of the provided Proxy Account.
* Note that in order to be able to use a Proxy Account in a specific job step, the Proxy Account needs to be activated for the specific subsystem (i.e. Operating system - CmdExec).
I hope you found this post useful!
Read more on this article...