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!