question

Ecej-4035 avatar image
0 Votes"
Ecej-4035 asked Joyzhao-MSFT edited

How do I change the start time of the job responsible for cleaning up of the ExecutionLog table?

This is regarding Microsoft SSRS ReportServer DB. Everyday at 2.00am there is a job/mechanism which executes the procedure-ExpireExecutionLogEntries in the ReportServer db. As an output of the query:
select * from ConfigurationInfo
There is a config ExecutionLogDaysKept. By default it's set up to 60 days. As a workaround it's possible to change the config to -1 in order to disable the cleaning up the executionLog table. BUT how to change the start time (2.00am) of running the procedure/mechanism/job?

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @Ecej-4035
By default, log entries are kept 60 days. Entries that exceed this date are removed at 2:00 A.M. every day. On a mature installation, only 60 days of information will be available at any given time. The retention time of log entries can be changed in Server Properties, but the cleaning time cannot be changed.
The following is part of the description in the official document:
113273-03.jpg

I have checked many documents and there is no indication that the time can be changed.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


03.jpg (38.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.