The database administrator can monitor and track all Job operations through the Job Logs.

Additionally, the database administrator can clean up the Job Logs using the PURGE_LOG procedure.

Where:

• LOG_HISTORY: To specify the retention period for the history in days. If the value is set to zero, all history will be purged.
• WHICH_LOG: To determine whether to deal with (JOB_LOG or WINDOW_LOG). This variable can take one of the following values: (JOB_LOG or WINDOW_LOG or JOB_AND_WINDOW_LOG).
• JOB_NAME: To specify the name of the Job whose data will be purged from the Job_Log.