The cleanup functionality was added to keep only a configured number of execution details
You can configure it on a per-job basis - configuration property Execution Details to Keep was added in the admin view
It accepts values from 1 to 20 and indicates the last X number of execution details records to keep deleting the rest. The "last" is identified by the triggerTime column. The cleanup is happening when the job is executed and track execution details is enabled.
This requires the DB schema update to add a new column, check Upgrade Guide
|
Note
|
If using liquibase to pull in base Broadleaf changelogs, then it is not necessary to manually run this script. |
BLC_SCHEDULED_JOB tableALTER TABLE blc_scheduled_job
ADD COLUMN number_of_exec_details_to_keep INT4;
UPDATE blc_scheduled_job
SET number_of_exec_details_to_keep = 10
WHERE number_of_exec_details_to_keep IS NULL;
ALTER TABLE blc_scheduled_job
ALTER COLUMN number_of_exec_details_to_keep SET DEFAULT 10;