0

I inherited a SQL Server environment. In (database engine) SQL Server Agent are two jobs defined that apparently belong to the report server.

First and only step in the first job:

exec [ReportServer].dbo.AddEvent @EventType='CacheInvalidateSchedule', @EventData='c5b50dad-33bb-40b8-a696-59b1a555e8e4'

First and only step in the second job:

exec [ReportServer].dbo.AddEvent @EventType='RefreshCache', @EventData='f1ae0c17-b150-4861-8d9a-8552036123a3'

enter image description here

Any ideas how these two jobs were originally created and what they do? When I check the report server, there are no schedules defined:

enter image description here

The connected report server is empty:

enter image description here

4
  • How do the SQL statements you posted relate to the jobs highlighted? Is it a step within the job? Are there other steps? That is what tells you what the job is doing - at least at a high level. Those statements look to be executing a stored procedure (AddEvent), so you'll want to investigate that to see exactly what it does with those parameters being passed in. – JShark Oct 23 '20 at 13:48
  • The statements are the first and only step in the respective job. There are no other steps. I have edited my question accordingly. Unfortunately, I cannot check what the stored procedure (AddEvent) does because the connected report server does not contain any database nor does it contain a programmability folder (I assume everything has been developed in visual studio). – Fusscreme Oct 23 '20 at 14:19
  • ReportServer is the name of a database on the current server, and that is where the stored procedure will be (if it still exists). – JShark Oct 23 '20 at 14:27
  • Thanks. I didn't know that the db would be stored in the database engine. The stored procedure was still there but somewhat nonsensical as the resulting table was empty. Fortunately though I found the answer (check below). – Fusscreme Oct 23 '20 at 15:08
0

First I ran

Use ReportServer  
select * from ExecutionLog3 order by TimeStart DESC  

This gave me a list of events that I matched with the scheduled times of the jobs:

enter image description here

So I went to the portal and checked the dataset. Turns out caching was enabled:

enter image description here

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.