Question2Replies837Views Karthik K Member since 2016 33 posts PEGA Posted: November 16, 2017Last activity: November 22, 2017 Closed Purge the Cases - which are older than one year ?Hi,We need to delete/remove the cases(criteria: current date - casecreatedate > 1 year), irrespective of case status using an agent.Could you please tell me, which one to use RDB or Obj ?Please suggest a Best Approach, such that application performance wont be impacted.***Updated by moderator: Lochan to add Categories*** Case Management Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoArnabGoswami Cognizant Technology Solution replied to Karthik KBest approach would be to use the OOTB purge and archive wizard. Here is the Help link for the same. https://pdn.pega.com/sites/pdn.pega.com/files/help_v73/procomhelpmain.htm#tools/purgearchive/aboutpurgearchivewizard.htm%3FTocPath%3DReference%7CTools%252C%2520accelerators%252C%2520and%2520wizards%7CPurge%252FArchive%2520wizard%7C_____0 Posted: 3 years agoKarthik K PEGA replied to ArnabGoswamiThanks Arnab!!. But, In my project, RDB methods are used, that will call a Stored Proc -- It will delete the records and returns the number of records deleted. I am not sure how they implemented, can we create stored procs for the pega internal tables also ? If so, is it similar, how we create for mysql or any other db ? Excuse me, If the above question seems to be stupid ?