How to: Create a SQL Server Agent Proxy (Transact-SQL)

Updated: 14 April 2006

This topic describes the steps required to create a Microsoft SQL Server Agent proxy.

  1. Execute sp_add_proxy, using the name of the proxy you want to add and the options for the proxy.

  1. 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).

Community Additions