Create a new proxy

Creating a proxy defines the connection between the Credential object and the executable set of defined jobs. Create a new proxy manually or using the TSQL command line.

Procedure

Step

SQL Server Management Studio

Command Line

1.

From the SQL Server Management Studio, select SQL Agent>Proxies, and right click Create New Proxy.

EXEC msdb.dbo.sp_add_proxy

@proxy_name = N'I360DBProxy',

@credential_name = N'I360DBCredential',

@enabled = 1

2.

Ensure that the new proxy is active to the following subsystems:

  • Operating system (CmdExec)

  • SQL Server Integration Services Package

EXEC msdb.dbo.sp_grant_proxy_to_subsystem @proxy_name = N'I360DBProxy', @subsystem_id = 3

EXEC msdb.dbo.sp_grant_proxy_to_subsystem

@proxy_name = N'I360DBProxy',

@subsystem_id = 11

3.

From the Principals tab, click Add Button, with the details as follows:

  • Principal type: Msdb role

  • Select from the list: I360DBRole

EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name = N'I360DBProxy', @msdb_role = N'I360DBRole'