EcoSys will automatically purge historical batch job logs from the database daily. The purge process can be controlled through the following server settings.
|
batchJob . purgeStartTime 'a0 |
default: 04:15, Requires a restart |
Controls the time the purge will start. |
|
batchJob.purgeDuration |
in hours, default: 1, min: 1 |
Controls the max duration the purge will run. |
|
batchJob.retentionDays |
default: 60, min: 30 |
How many days of records should be retained |
For a clustered EcoSys environment, the server settings should be configured the same way on all nodes. EcoSys will use locks so that only one node in the cluster runs the purge.
This purge process cannot be disabled.
If required, a manual purge can also be done using a utility script which is provided in the utils folder. Refer to the comments within this script to know how to use and execute it against your database as needed.
For Oracle Databases:
database/oracle/utils/fm_or_delete_batchjob_records.sql
For SQLServer Databases:
database/sqlserver/utils/fm_ss_delete_batchjob_records.sql