Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to clear some job_log views, dbms_scheduler.purge_log() does not work

621436Apr 21 2008 — edited Apr 22 2008

I have run thousands of event-based jobs and thus there are many records in dba_scheduler_job_run_details and dba_scheduler_job_log. How can I completely delete those records? I have tried:

DBMS_SCHEDULER.PURGE_LOG(log_history => 0, which_log => 'JOB_LOG');

But it only works for those periodical jobs, not for the event-based jobs. Those event-based jobs are invoked by sending msg into a queue. Thanks.

Message was edited by:
KingMing

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2008

Added on Apr 21 2008

#general-database-discussions

15 comments

13,267 views