Home Library Learn Samples Downloads Support Community Forums
0 out of 1 rated this helpful - Rate this topic

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

SQL Server 2005

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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.