Wednesday, March 21, 2012

How to Run Job without Sysadmin Role

Hi All,
I know this question have already posted frequently, and I've tried all
the solution that they're suggested, but still doesn't work. I've
changed job owner and also setup the SQL Server Proxy account and
password into that Non-SyAdmin user, but still failed when run the job.
Is there any other solution? Please help me...
ThanksWhat error are you getting when the job fails?
-Sue
On 9 Nov 2005 18:13:06 -0800, resant_v@.yahoo.com wrote:

>Hi All,
>I know this question have already posted frequently, and I've tried all
>the solution that they're suggested, but still doesn't work. I've
>changed job owner and also setup the SQL Server Proxy account and
>password into that Non-SyAdmin user, but still failed when run the job.
>Is there any other solution? Please help me...
>
>Thanks|||"Non-SysAdmins have been denied permission to run CmdExec job steps"
But never mind, i've solved now but i'm getting new error :
"The specified @.job_name (Name of Job) doesn't exist".
This happen when I changed job owner into sysadmin user not that
Non-Sysadmin user.
Oh yeah, I use sysadmin user for proxy account, so when a Non-Sysadmin
user run the job, they will use the proxy account, right?
So, what should I do now?
Thanks

No comments:

Post a Comment