Post reply

Access to Jobs history - bug?

  • January 24, 2023 at 2:58 pm

    #4141275

    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?

    Attachments:
    You must be logged in to view attached files.

  • January 24, 2023 at 5:36 pm

    #4141341

    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:
    http://www.sqlservercentral.com/articles/61537/

  • January 25, 2023 at 12:12 am

    This was removed by the editor as SPAM

  • January 26, 2023 at 12:57 pm

    #4141996

    Hi Michael,

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

    Thanks

  • January 26, 2023 at 1:25 pm

    #4141999

    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:
    http://www.sqlservercentral.com/articles/61537/

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

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