1 2 Previous Next 17 Replies Latest reply: Aug 13, 2012 9:11 AM by Ronald Rood RSS

    job running after bouncing database

    933651
      Hello!
      I have the following scheduled jobs :

      dbms_scheduler.create_job('JOB1',
      job_action=> 'PROC' ,
      repeat_interval => 'FREQ=DAILY; BYHOUR=08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23; BYMINUTE=2,12,22,32,42,52; BYSECOND=1',
      job_type=>'STORED_PROCEDURE', enabled=>TRUE);

      dbms_scheduler.create_job('JOB2',
      job_action=> 'PROC2' ,
      repeat_interval => 'FREQ=DAILY; BYHOUR=08,09,10,11,12,13,14,15,16,17,18,19,20,21,22,23; BYMINUTE=4,14,24,34,44,54; BYSECOND=1',
      job_type=>'STORED_PROCEDURE', enabled=>TRUE);

      At about 8 in the morning the database was bounced with the normal procedure of stop and start.
      After I noticed that the 2 jobs were both executed at 8:06.

      But this is not the time they were supposed to be executed from the scheduler.
      Later the execution was fine.
      Can somebody help me explain what has happened?
      Thanks in advance!
        1 2 Previous Next