How can non sysadmins run jobs?

  • Look into setting up SQLAgentCmdExec Proxy account. This account will enable non-sysadmins to own jobs that execute OS commands (including xp_cmdshell). In the SQL EM -> Select the SQL Server Agent -> (Properties) -> Job System Tab. Check the non-sysadmin job step proxy account at the bottom. Whichever account you use needs only run as a batch job permissions and any other permissions on the OS and the SQL server that the job needs.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply