Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Scheduler job does not run on time

User_C8FRMMar 1 2018 — edited Mar 5 2018

Hello,

I'm new here, so sorry if I forget to put in all the information.

We are using Oracle 12c (12.2.0.1.0) and there is an issue with dbms_scheduler.create_job. The problem is with the time of the actual start date.

We've created the job like this:

begin

  sys.dbms_scheduler.create_job(job_name            => '<JOB_NAME>',

                                job_type            => 'PLSQL_BLOCK',

                                job_action          => 'BEGIN INSERT INTO <TABLE>; COMMIT; END;',

                                start_date          => to_date('17-11-2017 09:18:35', 'dd-mm-yyyy hh24:mi:ss'),

                                repeat_interval     => 'Freq=MINUTELY;Interval=10',

                                end_date            => to_date(null),

                                job_class           => 'DEFAULT_JOB_CLASS',

                                enabled             => false,

                                auto_drop           => false,

                                comments            => '<COMMENT>');

end;

/

It should initiate every 10 minutes, but on some occasions it starts randomly.

For example:

First job requested start date was 2018-02-28 02:50:00 and actual start date was the same - 2018-02-28 02:50:00, a quick job ant that's it.

The next job had the requested start date 2018-02-28 03:00:00 but the actual start date was 2018-03-01 09:02:04.

Has anybody encountered something like this?

Thanks in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2018
Added on Mar 1 2018
10 comments
5,671 views