access to view job history only RRS feed

  • Question

  • hi, Our devs belong to an AD group. The AD group has been added to our prod database with read only permission. (devs can only query, view tables, sp's ..). The server is sql server 2008 (non r2). We also need this AD group to be able to view jobs and job history from sql agent. (to see errors when jobs fail etc). They should not be able to start/edit/delete jobs. How can this be accomplished from a sql dba perspective ? Please be specific/detailed and attach screenshot if possible. Thanks
    Wednesday, September 18, 2013 4:21 PM


All replies