Transact-SQL job step to run under proxy

• Matthew.Peters 13064

  SSC-Addicted

  Points: 460

  More actions

  March 14, 2013 at 5:35 pm

  #275287

  Hello

  I have a Transact-SQL job step that I want to run under a proxy however I cannot get it to work. I have created the credential then created the proxy to run under all subsytems however when I try and choose the proxy in the 'run as' drop down it does not appear. I am running sql server 2008 enterprise edition

• Andrew G

  SSChampion

  Points: 12809

  More actions

  March 15, 2013 at 1:35 am

  #1597368

  You need to give permission to the Agent Job owner to use the Proxy.

  EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'domain\user', @login_name=N'domain\user'

  GO

  Or browse to Principals under the proxy in SQL Agent.