Hi all,
a database job should be executed every day from 14:00 to 19:00 on my 18c database.
I have created a window with start_date = 04.12.2018 14:00:00 and duration = 5 hours.
But the job starts only once a day at 14:00...
Here is my code, what do I do wrong?
BEGIN
DBMS_SCHEDULER.CREATE_WINDOW(
window_name => 'MYWINDOW1',
resource_plan => 'DEFAULT_MAINTENANCE_PLAN',
start_date => to_timestamp('03.12.2018 14:00:00', 'DD.MM.YYYY HH24:MI:SS'),
duration => numtodsinterval(5, 'hour'),
repeat_interval => 'freq=daily;byday=MON,TUE,WED,THU,FRI,SAT,SUN;byhour=14;byminute=0;bysecond=0');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => '"MYSCHEMA"."MYJOB1"',
schedule_name => '"SYS"."MYWINDOW1"',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN myprocedure; END;',
number_of_arguments => 0,
enabled => FALSE,
auto_drop => FALSE,
comments => 'My test job');
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"MYSCHEMA"."MYJOB1"',
attribute => 'store_output',
value => TRUE);
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"MYSCHEMA"."MYJOB1"',
attribute => 'logging_level',
value => DBMS_SCHEDULER.LOGGING_OFF);
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"MYSCHEMA"."MYJOB1"',
attribute => 'max_run_duration',
value => to_dsinterval('+00 01:00:00.000000'));
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"MYSCHEMA"."MYJOB1"',
attribute => 'schedule_limit',
value => to_dsinterval('+00 01:00:00.000000'));
DBMS_SCHEDULER.enable(
name => '"MYSCHEMA"."MYJOB1"');
END;
/
Thank you very much!