I have created an archived table named A_XXX. The archiving process is happening through an integration schedule. Now, the data in this archived table needs to be flushed after one week. How can this be implemented?
Question
delete archive table/data
+2
+28Hi
You can create a scheduled process and run a bulk update and delete the relevant records.
You might need to create a view to identify the records that are older than a week and use it in the XML message.
Cheers!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.