I have over 100 different datasets on an ssrs-2016 site. Each one of those datasets needs a new caching schedule. I have created a shared schedule to apply to each dataset, but I am wondering if there is a quick way to apply that schedule to each dataset without clicking through each one and adding the schedule.

Can this be done through DML against a report server database? If so, is it wise to run DML in a report server database?

  • check [ReportServerTempDB].dbo.ExecutionCache to see if it helps. – Kin Shah Sep 20 '19 at 20:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.