Create a quartz job to be able to delete the old BackgroundTask entries from the database

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE
• Fix Version/s: 6.2.X EE
• Component/s: Portal Services, Portal Services > Background Tasks, Portal Services > Scheduler
• Labels:
  • ee-ts
  • liferay-fixpack-portal-158-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal-ee/pull/17845

Using the pattern of LPS-53931

On master and 7.0, the scheduled job that purges old ExportImportConfigurations takes care of purging the related BackgroundTasks as well, so this is not a problem there. But unfortunately there is no ExportImportConfiguration model on 6.2, it was a new feature for 7.0. So we need to make a unique solution for purging old BackgroundTasks on 6.2.

Test steps:
1. Set

background.task.clean.up.check.interval=1
background.task.clean.up.keep.count=2

in you portal-ext.properties
2. Turn on staging and do publications to live several times (more than 2 times)
3. Check the backgroundtask table in the database: there should be a record for each publications
4. Wait an hour, don't shut down the portal
5. Check the backgroundtask table in the database: only the latest 2 background tasks should exist