DBMS_SCHEDULER executes a job twice
Problem: I create and a scheduler job to run a stored procedure and start it. The job runs twice in sucession although it should only one once
Environment
- Host OS Linux 64-bit
- Oracle 11g R1.0.6
Here is how I create and run the job.
begin
dbms_scheduler.create_job (
job_name => 'ROAD_REPROJECT'
, job_type => 'STORED_PROCEDURE'
, job_action => 'REPROJECT_ROAD'
, enabled => TRUE
, start_date => SYSDATE );
commit;
dbms_scheduler.run_job( 'ROAD_REPROJECT', FALSE );
end;
From user_scheduler_job: schedule_type = 'ONCE', AUTO_DROP = TRUE, RESTARTABLE=FALSE
What am I missing that makes this job run twice in succession?
Thanks