Dbms_scheduler auto drop

Oracle 11.2.0.3 EE on Aix.  

I have written a procedure that will create scheduler jobs based on an argument, then run them. Going through the documentation, I determined that if I want to run a scheduler job in a separate session when calling it from a stored procedure, I had to first create the job disabled using DBMS_SCHEDULER.CREATE_JOB, then use the DBMS_SCHEDULER.RUN_JOB procedure, and set the argument USE_CURRENT_SESSION to FALSE.  

However, I also want the drop to drop automatically once it has been run. To accomplish this, I set the AUTO_DROP option to TRUE. According to the documentation, since I did not set a repeat interval, it should drop the job after a single run. However, the jobs that are generated from this SP do not drop automatically. Below is the code segment that creates and runs the job. Is there a change that will drop the job automatically. For now, I have modified the code to drop jobs matching the naming convention at the start of the job, but I would prefer that they were dropped automatically.  

      dbms_scheduler.create_job(
           job_name=>'ASYNC_ANALYZE_'||to_char(analyze_cursor2.group_number),
           job_type=>'PLSQL_BLOCK',
           job_action=>'BEGIN  async_analyze_group('||analyze_cursor2.group_number||'); END;',
           comments=>'Asynch analyze job for tables requiring special attention. Argument is the group number from the stats_group table',
           auto_drop=>true,  --set this to false for debugging purposes, job will remain on dba_scheduler_jobs view until manually removed
           enabled=>false);
      dbms_scheduler.run_job(job_name=>'ASYNC_ANALYZE_'||to_char(analyze_cursor2.group_number),use_current_session=>false);

Sent from my iPad--
http://www.freelists.org/webpage/oracle-l Received on Mon Apr 27 2015 - 17:37:53 CEST