DBMS Scheduler Job Log getting Purged
634598Aug 17 2011 — edited Aug 17 2011Hello,
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.