8.6.5.2 KDD_DR_JOB Table

The KDD_DR_JOB table stores the start and end date and time and the status of each process that the Data Retention Manager calls. The following table provides the table’s contents.

Table 8-18 BUSINESS.KDD_DR_JOB Table Contents

Column Name Description
JOB_ID Unique sequence ID.
START_DT Start date of the process.
END_DT End date of the process.
STATUS_CD

Status of the process:

  • l RUN:Running
  • l FIN:Finished successfully
  • l ERR:An error occurred
  • l WRN:Finished with a warning