Access to Jobs history - bug?

  • Hi all,

    A few of my users reported a weird issue with access to agent's jobs. I wander if that's the bug in management studio and what I can do about that.

    If I go with my account with SA privileges to SQL Server Agent > right mouse click on any job > Properties at the very button I can see 'View Job History' link that I can click on and I will be redirected to job's history.

    I am trying to do the same with the account with 'only' SQLAgentOperatorRole in and db_owner in msdb and the link on the last step is grayed out (please see attachment).

    It does not seem to be a problem with the privileges because I can end up in the targeted view by going SQL Server Agent > View History directly. The only problem is with that link.

    I have test that on a couple of versions the newest is SQL Server 2019 (RTM-CU13). I use management studio v18.9.2. Is it just an management studio bug or I am missing something?

    You must be logged in to view attached files.
  • Grant the account that cannot see the logs access to the folder where the logs are stored.

    On my local machine, that's C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:

  • This was removed by the editor as SPAM

  • Hi Michael,

    Thanks for such quick response. Could you advise how can I grant SQL's login access to windows folder?


  • If the user is connecting using a SQL login, then the service accounts running SQL and SQL Agent need to be granted access.

    If they are connecting using Windows Authentication, then that login will need to be granted access to that folder.

    I think it may make sense to create a group in AD, add the users to that group, and then grant that group perms.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:

Viewing 5 posts - 1 through 4 (of 4 total)

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