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

1. Use the GET api/reportserver/v2/scheduledtasks endpoint to retrieve all scheduled tasks.
2. 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.
3. 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.

1. Backup the database - Storage Backup.
2. 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.

See Also

• Report Server API Client - Telerik Report Server
• Report Server REST API
• Storage Backup - Telerik Report Server