Post reply

Permission required to administer SQL jobs

  • February 28, 2006 at 9:38 am

    #167247

    Hi

     I am looking for permissions required to view scheduled jobs by non sa logins (SQL 2000 SP3a)

    Any help will be appriciated

    Thanks

    Alpesh


    Alpesh

  • February 28, 2006 at 9:58 am

    #623743

    Alpesh,

    Try adding the users to TargetServerRole in MSDB.  You may have to give TargetServerRole permission to execute sp_help_job, sp_help_jobstep, sp_help_jobschedule, and sp_help_jobhistory.

    Greg

    Greg

  • February 28, 2006 at 1:33 pm

    #623798

    Thanks Greg it works

    Alpesh


    Alpesh

  • March 1, 2006 at 8:16 am

    #623991

    Just a warning... this is in place to allow multiserver administration. As a result, if Microsoft changes how this behaves (look at the changes from SQL Server 2000 SP2 to SQL Server 2000 SP3 for an idea), you may be broken. As a result, Microsoft doesn't support the use of this role. Other than that, it seems to work for the time being.

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

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