Hiding SSRS Jobs does not work

• ktflash

  Default port

  Points: 1400

  More actions

  October 18, 2022 at 1:30 pm

  #4100960

  Ahoy,

  i have a weird/annoying problem which i cant get my head around.

  We have implented the following solution to hide SSRS from the Jobhistory in the Agent.

  But somehow this does not work for my user/login, which means i still see them in the jobhistory.

  When my colleagues browse it, the SSRS stuff is hidden, but with my login it is not.

  We are using Windows AD authentication, as devs we have admin permissions.

  Weird thing is, i even edited the procedure temporarely and changed the where to: 0 = 1

  which should have prevented any output/listing of jobs (?), but that did not change my SQL Server Agent Job history output at all.

  Somehow when i open the sql server agent the server does not care about this procedure at all?

  I even installed a SSMS fresh locally on my pc instead of using the SSMS in my usual RDP session, but the result is still the same.

  Anyone has any ideas what the reason might be?

   

   

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 19, 2022 at 2:10 pm

  #4101475

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.