Unplanned
Last Updated: 22 May 2024 23:35 by Jason
Jason
Created on: 02 Mar 2022 22:04
Type: Feature Request
2
Scheduled Task Execution Retention Policy

Currently the Report Server appears to keep the execution history of scheduled report tasks indefinitely.  The task execution history is a very useful feature but there appears to be no way to limit the history to a certain amount of time.  For our use case it is unlikely that we will need to go further back then 1 or two months in the history and as we get months an even years of history (which includes the execution and related documents) the time needed to backup and restore the Report Server increases.  We only have about 30 scheduled reports that run each day but over a year that is 10,000+ executions that are stored and anything over a month or so old has little value to us.  I am not sure if these also have an impact on the overall performance of the Report Server or at least the Scheduler portion of the UI but that would be another reason to limit the retention.

Currently the only method to delete the executions is to either (a) do it manually via the UI (screenshot below) or (b) to write an application that deletes executions outside our retention window using the API to query and then delete them.  Method (a) is too time consuming for a person to do and (b) will require writing the application but then also monitoring it's status and keeping up with any changes in the API over time.

I would propose adding some method of allowing users to set a "retention period" for scheduled task executions.

  • The retention period would ideally be able to be set globally and overridden for a particular task
  • The retention period would be specified in days
  • To actually remove the old executions you could create a task that runs once a day and is executed by the windows service that exists -OR- each time the task executes to run the report it can also look to see which historical executions are older then the retention period and delete them.
  • The removal of the historical tasks should also delete any associated documents

 

Implementing this would allow for much quicker upgrades, backups, and restores of the Report Server.

4 comments
Jason
Posted on: 22 May 2024 23:35
Thanks Waz - We do not do a backup anymore, it takes many hours so before upgrades we snapshot the VM and that is our rollback plan.
Waz
Posted on: 22 May 2024 23:28
This would be really useful for us too, we just had an update take longer than expected because our daily reports have increased and the backup operation took over half an hour because so many historic reports were kept. Also this is going to become a problem in the future as the server we're hosting on has limited space. Even just a button to delete all the historic reports for a particular scheduled action would be good.
ADMIN
Todor
Posted on: 09 Mar 2022 12:28

Hello Jason,

Thank you for this absolutely valid and reasonable feature request and the detailed explanation of the scenario where it would be needed.

We appreciate also the suggested behavior and the approaches for how it may be implemented. We will consider all of this.

As a token of gratitude, we have updated your Telerik points.

Regards,
Todor
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Jason
Posted on: 02 Mar 2022 22:12

Screen shot referenced above -->