Saturday, February 25, 2012

CmdExec job step permission

Is there anyway I can make a "CmdExec" job step run by a non system
admin?Set up the proxy account with the right permissions. Then non sa users will
use the proxy account to run cmdexec jobs.
Right click on the SQL Agent in EM and choose Properties. Then go to the
Job System tab and at the bottom you will see the place to enable this.
Andrew J. Kelly SQL MVP
"SQL novice" <balacr@.gmail.com> wrote in message
news:1129801114.758202.200050@.g14g2000cwa.googlegroups.com...
> Is there anyway I can make a "CmdExec" job step run by a non system
> admin?
>|||Thanks much for the response. It was very helpful.

No comments:

Post a Comment