Post reply

Doubt on SQL jobs

  • February 10, 2010 at 8:03 am

    #218946

    I have a doubt.. is it possible to give permissions to users to execute only a few jobs and not others..

    If Yes where should i specify?

    Kindest Regards,
    Paarthasarathy
    Microsoft Certified Technology Specialist
    http://paarthasarathyk.blogspot.com

  • February 10, 2010 at 8:24 am

    #1116866

    Guys, Have i confused you with my question..

    Let me elaborate..

    Let us assume, we have 10 SQL named users.. All of them with dbadmin privilege..

    I am the system administrator

    I prefer not to allow a few users to invoke\start a job manually from SSMS\enterprise manager..

    Let me if this is possible

    Kindest Regards,
    Paarthasarathy
    Microsoft Certified Technology Specialist
    http://paarthasarathyk.blogspot.com

  • February 10, 2010 at 10:03 am

    #1116975

    There are some SQL Server Agent fixed database roles in msdb that may help you if you assign some users to them. See the details in BOL for SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole to see if they fit your situation.

    Greg

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

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