SQL Agent Proxy

• vino5786

  Right there with Babe

  Points: 743

  More actions

  July 1, 2013 at 8:46 pm

  #295870

  Hi Guys,

  We are encountering an issue while using SQL Agent proxy account to run cmdexec.

  We hv login "sch" and granted sysadmin and linked it to a credential and this has been added to subsystem CMdExec. But still we are getting this error

  Unable to start execution of step 1 (reason: JobOwner sa doesn't have permissions to use proxy 3 for subsystem CmdExec).

  I also tried changing the job owner to "sch" it doesnt help.

  Any help would be appreciated

  Thanks for your time.

  Cheers

  v