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

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

To create a 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.

To create a credential

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

See Also

Concepts

Creating SQL Server Agent Proxies

Other Resources

sp_add_proxy (Transact-SQL)
sp_enum_login_for_proxy (Transact-SQL)
sp_enum_proxy_for_subsystem (Transact-SQL)
sp_enum_sqlagent_subsystems (Transact-SQL)
sp_grant_login_to_proxy (Transact-SQL)
sp_grant_proxy_to_subsystem (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance