Execute permission on job


  • i have created 5 jobs in sqlserver. I need to provide only below permission to user. How to achieve this .

    1. Execute job
    2. View job history

    Thanks for your help.
    Friday, December 23, 2011 5:42 AM

All replies

  • Please refer following MSDN article . The article explains what database role you must grant to users so they can create or execute jobs by using SQL Server Agent .

    Thanks,Suhas Vallala

    Friday, December 23, 2011 7:07 AM
  • Hi,

    Give to user 'SQLAgentOperatorRole' permission in msdb database and the user would be able to view job history and execute the jobs.


    • Edited by VVinayPrasad Tuesday, December 27, 2011 9:48 AM
    • Proposed as answer by Dv111 Monday, April 13, 2015 1:44 PM
    Tuesday, December 27, 2011 9:48 AM