New to Telerik Report Server? Download free 30-day trial

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

In this article