Managing the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 123

6. Click OK to accept the settings.
7.

We should see the new credential in the list in the Object Explorer.

8. The steps we followed using GUI tool can be accomplished by using the following

TSQL statement:
--Implementing SQL Server Agent security
--Creating a SQLAgent credential
USE[master]
GO
CREATECREDENTIAL[Secure DBIA SQL Agent]WITHIDENTITY=N'DBIA-SSQA\
tseuG',SECRET=N'Guest'
GO

9. Locate the SQL Server Agent node in the Object Explorer. Expand the node and
locate the Proxies node.
10. If you expand the Proxies node, you will see a list of SQL Server Agent task types.
Any proxy that you have configured for a specific task type will appear in the node list
associated with that task.
11. Right-click the Proxies node and select New Proxy from the menu to open the New
Proxy Account dialog.
12. Enter a name for the proxy in the Proxy Name text box.
13. Now enter the name of the previously created credential in the Credential Name
text box.
14. Select the tasks (refer to the following screenshot) for which you want this proxy to
authenticate. If you click the Subsystem check box, all tasks will get selected.