dbms_scheduler start_date and repeat_interval
Hi All,
So I have a question about setting up a job in dbms_scheduler using start_date, repeat_interval and whether the job is DST aware.
running 12.2.0.1 or 19.3.0.0
If I set up like this:
dbms_scheduler.create_job (
job_name => 'TEST',
start_date => TO_TIMESTAMP_TZ('2019/06/18 14:03:33.482282 -07:00','yyyy/mm/dd hh24:mi:ss.ff tzr'),
repeat_interval => 'FREQ=DAILY;BYHOUR=21'
etc
Will this job be DST aware and start at 9pm all the time or will it start at 8pm during DST?
If I set up like this:
dbms_scheduler.create_job (
job_name => 'TEST',
start_date => NULL