Database Utilities (MOSC)

MOSC Banner

DBMS_SCHEDULER executes a job twice

edited Mar 9, 2020 5:04AM in Database Utilities (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center