Post reply

assign rights to view or create sql jobs

  • April 19, 2011 at 12:42 pm

    #238802

    We have a database develper needs to create sql jobs on the server.

    I did assign him the dbowner of the database he's working on, but would like also assign her rights to view all the sql agent jobs and create jobs.

    Is there a way of doing that? from both GUI and sql

    Thanks

  • April 19, 2011 at 1:37 pm

    #1313610

    USE [msdb]

    GO

    EXEC sp_addrolemember N'SQLAgentOperatorRole', N'your user account'

    GO

    In the GUI add the person to the SQLAgentOperatorRole under the msdb database. (d-click persons login, click user mapping, put a check into the box next to msdb, then select the role from the role membership window).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 19, 2011 at 1:41 pm

    #1313614

    Thanks, I tried, it works perfectly

  • April 19, 2011 at 1:43 pm

    #1313615

    You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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