Job Database Cleanup

This feature allows to periodically clean (“purge”) a certain amount of jobs from the database and so from the job dashboard in IO/CO/HK. By activating the corresponding switch button the cleanup will be executed on a daily basis at a desired time (“Time of execution”). This will trigger the IO endpoint and therefore the deletion task. The reference for the time of execution is the time of the server in UTC zone. Please consider that there can be a “drift" due to the fact of a time shift towards a different time zone.

There are two “Cleanup options” to perform this feature:

Cleanup option: Jobs Count

By choosing the cleanup option “Jobs Count” you have to insert the total amount of latest jobs (between 1 and 10000), that should be kept.

Example:

If you enter the number 1000 in the field “Jobs count to keep", only the last 1000 tasks are saved in the dashboard/database. Everything else is removed after the task is completed.

Cleanup option: Relative Date Filter

By choosing the cleanup option “Relative Date Filter” there are 3 input fields to be filled out. The field “Relative date comparator” allows to choose the upper boundary for the relative filter and can be selected between “SMALLER_TODAY” and “SMALLER_EQ_TODAY”. The upper limit for the relative date filter can be set in the field “Relative date limit” only as negative value. As a final input the user has to select within the field “Relative date time span” which time unit should be the reference for the execution of the database cleanup (DAY(S) or MONTH(S)).

Example:

Day of execution: Sunday Relative date limit: -3 Relative date time span: DAY(S) Relative date comparator: SMALLER_TODAY —> All jobs from Saturday, Friday and Thursday will be purged SMALLER_EQ_TODAY —-> All jobs from Sunday, Saturday and will be purged

Last updated