Based on the Tables provided, you're using Pega Robotics.
Instead of Purging DB Tables manually, It's advisable to create / setup Archival and Purging DB Tables where as Records will be moved to Archival Table first and Purging the Records later. DBA's can help you to achive this requirement by creating Stored Procedures as a Job in the Database side.
You can define the Archival of Records from DB Tables older than 30days and move it to Purging Table post 60days. You can adjust them as per your Organization / DBA's advise.
Posted: 3 months ago
Posted: 13 Oct 2022 8:43 EDT
Timothy Keating (TimothyK8255)
Thanks for your update. Yes you can truncate those old records with a Query as you know it better than me. However, Have it a discussion with Application Team and ddecide that How many days old Records that you wanted to retain and proceed. It's a better option.