Skip to Main Content

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!

DBMS Scheduler Job Log getting Purged

634598Aug 17 2011 — edited Aug 17 2011
Hello,
I am facing an issue with the DBMS_SCHEDULER job log getting purged after every three days.
I checked the log_history parameter for the job class to which this job belongs and the parameter is 3 days. So, that makes sense. However, the problem is that the most recent log is getting purged and the older ones are retained by the scheduler.

Is the functionality not to keep the most recent logs and delete the older ones. I really need the log for some critical jobs and this purging is causing many issues.

Could you please help me in sorting this out as to why the most recent logs are getting purged. The individual logging for the job is set to LOGGING_FULL. and the job class also has LOGGING_FULL.
Resource Consumer Group for this class is DEFAULT_CONSUMER_GROUP.
Thanks for help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2011
Added on Aug 17 2011
2 comments
649 views