ever growing SCHEDULER$_JOB_ARG table
SandiMSep 23 2011 — edited Sep 23 2011Database 11.1.0.7 ; New to Oracle Scheduler.
Our first job is using a PL/SQL module that creates an external job, sets 3 arguments, sets attributes, and runs the job. All seems to be working fine.
My question is about the SCHEDULER$_JOB_ARG table in my nightly export. It's growing at a rate of 2M per week since June.
Is SCHEDULER$_JOB_ARG the arguments for each job? auto_drop is set to TRUE, so wouldn't the job and the arguments be removed when the job is completed?
I'm not seeing anything in the 11g documentation that explains what this table is. I'm wondering if there are additional housekeeping tasks I could/should be doing.