Database Administration (MOSC)

MOSC Banner

dbms_scheduler start_date and repeat_interval

edited Mar 25, 2020 5:01AM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center