Re: How to Run Job without Sysadmin Role

resant_v_at_yahoo.com
Date: 11/10/05

  • Next message: Willy: "Re: Preventing Injection - Client Side" 
    Date: 9 Nov 2005 19:16:31 -0800

    "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

  • Next message: Willy: "Re: Preventing Injection - Client Side"

    Relevant Pages

    • Re: SQL Proxy Agent and cmdExec
      ... when I said I had various results playing with the switch for Non-SysAdmin ... I meant on some servers I was able to set a non-sysadmin ... Unable to set the SQL Agent proxy account because of the reason listed ...
      (microsoft.public.sqlserver.programming)
    • Re: xpsql.cpp
      ... proxy account was not there (on one server wasn't there; ... I run a stored procedure sp_test, with user B0 (non-sysadmin domain ... output is the account that Sql Server is running with. ...
      (microsoft.public.sqlserver.security)
    • job execution sql agent
      ... I am using a proxy account to run a scheduled job. ... The proxy account is non-sysadmin, and is setup ... to do all the DTS stuff required. ...
      (microsoft.public.sqlserver.security)
    • job execution sql agent
      ... I am using a proxy account to run a scheduled job. ... The proxy account is non-sysadmin, and is setup ... to do all the DTS stuff required. ...
      (microsoft.public.sqlserver.security)