clean-up-scheduled-reports-activities.md

title	description	type	page_title	slug	tags	res_type	ticketid
Cleaning Up Scheduled Reports Activities	Learn how to improve performance by deleting old scheduled reports activities in Telerik Report Server using REST API or SQL script.	how-to	How to Delete Old Scheduled Reports Activities	clean-up-scheduled-reports-activities	report server, rest api, scheduled tasks, sql script, performance	kb	1662255

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)]({%slug storage-settings%}#microsoft-sql-server-mssqlserver) storage, the scheduled task executions can be deleted through SQL.

1. Backup the database - [Storage Backup]({%slug 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]({%slug report-server-api-client%})
• Report Server REST API
• [Storage Backup - Telerik Report Server]({%slug storage-backup%})