Check Job definition

Hello,

Oracle 11.2. I had problem with AUD$ data, so I moved this table to dedicated TBS and cleaned up data older than one month.

I implemented afterwards two jobs to clean-up this regularly (every 30 days).

Both jobs are running fine:

JOB_NAME

OWNER

STATUS

COMPLETION_DATE

RUN_DURATION

----------------------------------------------------------------- --------------- ---------- -------------------- --------------------

PURGE_DB_AUDIT_TRAILS

SYS

SUCCEEDED  12-FEB-2020 22:38:40 +000 00:00:00

JOB_NAME

OWNER

STATUS

COMPLETION_DATE

RUN_DURATION

----------------------------------------------------------------- --------------- ---------- -------------------- --------------------

SET_LAST_ARCHIVE_AUD_TIMESTAMP

SYS

SUCCEEDED  12-FEB-2020 00:00:00 +000 00:00:00

But I see that oldest entry date in log stays at the same level as 12 days ago:

SYS@orcl> SELECT COUNT(*),MIN(NTIMESTAMP#) "Earliest" from AUD$;