We recently upgraded our report server after years of operation due
to various technical challenges. Our system currently manages over 250
reports and more than 100 scheduled tasks, all of which have been
running for the past seven years. The backup process has become
significantly delayed, as we are handling over 70GB of data, primarily
composed of daily generated reports related to executed scheduled tasks.
While we regularly review execution history (execution date & time) for debugging purposes, but we never use the
reports of executed scheduled task for all historical records. This leads to unnecessary storage usage, which will continue to grow over time.
Manually deleting seven years' worth of historical reports across over 100 tasks is not feasible, and scripting this deletion would impact the performance of our already heavily utilized report server.
I believe the execution history is valuable for everyone for debugging purpose. However, the associated reports which takes significant amount of storage space should be kept optional. Therefore, I propose the following features:
During the configuration of scheduled tasks, include an option (similar to an "Enabled" checkbox) that allows users to choose whether to retain or delete the associated report for each scheduled task execution. This would only apply to reports generated for future task executions.
Introduce a REST API endpoint within the Scheduled Tasks framework that would facilitate the deletion of historical tasks and their associated reports.
These enhancements would greatly improve our report management and storage efficiency as we have over 10+ intensely used report servers for different businesses.
These are some feature requests which align with our goals -