Post reply

View SQL server Agent job history ONLY

  • July 6, 2015 at 4:25 am

    #398697

    Hi,

    I want to give developers access to view SQL Job history, but not let them inhert permission to create local jobs like they get with the fixed server roles.

    how can this be achieved? Or can it only be achieved by giving them access to the tables in msdb and querying them?

  • July 6, 2015 at 4:30 am

    #1810390

    You could write a stored procedure to return the results, with a parameter of jobname. then just grant them permissions to execute the stored procedure.

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

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