Closed dustinestes closed 1 month ago
Beginning work on this maintenance task
After investigation, it was found that this functionality already exists as a built-in Maintenance Task. This is enabled by default and is configured daily to remove anything 60 days or older. that is unreferenced.
Description Create a script to be performed as part of the maintenance of the database that can remove old revisions of applications that may no longer be necessary.
Purpose Applications that are successfully deployed may not need revisions from previous failed packaging attempts and testing. This revision data just takes up space and causes locks/conflicts. It would be helpful to remove old data to cleanup the database.