Cleaning Up Scheduled Reports Activities
Environment
Product | Progress® Telerik® Report Server |
Description
When using Telerik Report Server for an extended period, the UI for editing reports can become slow due to the accumulation of activity records. This article outlines methods to clean out old scheduled report activities to improve performance.
Solution
Using the Report Server REST API
- Use the GET api/reportserver/v2/scheduledtasks endpoint to retrieve all scheduled tasks.
- Use the GET api/reportserver/v2/executions/scheduledtasks/{scheduledTaskId} to get all executions for a specific scheduled task. Inspect the
ExecutionDate
property to identify executions to delete. - Use the DELETE api/reportserver/v2/executions/scheduledtasks/{scheduledTaskId}/{executionId} endpoint to delete specific executions based on your criteria.
For more information on using the REST API, consult the Report Server API Client documentation.
MSSQL Storage - Using SQL Script
If the Report Server uses Microsoft SQL Server (MsSqlServer) storage, the scheduled task executions can be deleted through SQL.
- Backup the database - Storage Backup.
- Delete all scheduled task documents using the following SQL statement:
DELETE [ReportServer].[dbo].[tr_Object]
WHERE Id LIKE 'TRS\1\Sd%'
Replace
[ReportServer]
with the name of the database.