PointForce Enterprise Purge Programs - Daily

Purge programs are designed to remove data from the database which in turn improves the performance of your system. If automation of any purge program is required, then contact smbservices@tecsys.com for a quote to write the scripts necessary for the automated process to run from the Windows Task Scheduler (i.e. "Scheduled Task" in Windows 7).

The following purge program should be run daily:

Purge Program Description Recommendation
Purge Transaction Log
Remove records directly from the live transaction log and create date-based archive files in the RP Archives directory.
[File: RPTL]
Run weekly at a minimum. Your transaction log should not get larger than 100,000 records. If it takes 3 days to reach this volume, then CC44 should be run every 3 days.