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

Question

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?

Answer 1

Hi @Ecej ，
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:

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.

Answer 2

The start time of the job responsible for cleaning up the Execution Log table can be changed by opening the SQL Server Management Studio, connecting to the Reporting Services instance, opening the Jobs folder, right-clicking on the job named

“SharePoint 2013 Reporting Services Execution Log Cleanup Job” and choosing Properties. On the Job Step tab, click on the “SharePoint 2013 Reporting Services Execution Log Cleanup Job” step and then click the “Edit…” button. In the “Command” text box,

you will see a line that starts with “PowerShell”. After this, you will see a parameter “-Schedule Start Time”.
This parameter controls the start time of the job. By default, the value is set to 1:00 AM.
You can change it to any other value. After you change the value, click OK.
You should see the new value in the “Command” text box. Click OK to save the changes to the job.