DBMS_SCHEDULER.PURGE_LOG
This is a branch (side question) from ORA-27412 - need another set of eyes
Looking at why some jobs were not listed in DBA_SCHEDULER_JOB_LOG, I found the answer but that led me to look at record retention for that view.
SQL> select count(*) from dba_scheduler_job_log; COUNT(*)---------- 1266721 row selected.SQL> select min(log_date) from dba_scheduler_job_log;MIN(LOG_DATE)---------------------------------------------------------------------------14-MAR-10 01.23.38.418445 PM -05:001 row selected.SQL> --
So looking for possible ways to do housekeeping and delete obsolete rows, I find DBMS_SCHEDULER.PURGE_LOG. Which says "By default, the Scheduler automatically purges all rows in the job log and window log that are older than 30 days. The