PMS table auto backup Service

Current Functionality:

This has been handled through external scripts manually.

Enhancement:

PMS Backup Service will fetch the data from the PMS_JOB_INFO table in a regular interval time based on the configured query (Ex: status = 3 for completed jobs) and it will insert those records into the destination backup table. Furthermore, it will delete the fetched jobs from the source PMS_JOB_INFO table, resulting in fewer records in the PMS table during runtime.

Benefits:

• Ease of management

• Improves application speed and performance.