How to: Create a SQL Server Agent Proxy (Transact-SQL)
SQL Server 2008 R2
This topic describes the steps required to create a Microsoft SQL Server Agent proxy.
To create a SQL Server Agent proxy
Execute sp_add_proxy, using the name of the proxy you want to add and the options for the proxy.
To create a credential
Execute CREATE CREDENTIAL, providing the credential name, the name of the account to be used (usually a Windows account), and, optionally, you can also specify a secret. For more information, see CREATE CREDENTIAL (Transact-SQL).
