Hi Saran,
I agree with the above-mentioned points - there is no OOTB functionality in MAS9 to handle automated cleanup of Message Tracking records.
In previous implementations, we have addressed this by developing a custom Cron task to purge older records. The cleanup criteria can be configured based on requirements - for example, using the Status Date, or any custom attribute defined for data retention.
One important consideration is to ensure that the cleanup is performed consistently across all related tables to maintain data integrity. This typically includes:
MAXINTMSGTRKDTL, MAXINTERROR, MAXINTERRORMSG, MAXINTMSGTRK
Hope this helps!
------------------------------
Aiman Ansari
Solution Architect
Naviam (formerly ZNAPZ)
Breda
------------------------------