none
Execute permission on job

    Question

  • 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 .
    http://msdn.microsoft.com/en-us/library/ms190926.aspx

    --------------------------------------------------
    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.

    Thanks


    VVinayPrasad
    Tuesday, December 27, 2011 9:48 AM