Report server scheduled job location

Question

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'

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

The connected report server is empty:

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, 2020 at 14:19

Fusscreme · Accepted Answer · 2020-10-23 15:04:16Z

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:

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

answered Oct 23, 2020 at 15:04

Fusscreme

1012 bronze badges

Add a comment |

1 Answer 1