oracle - DBMS_SCHEDULER Calendaring Syntax -

oracle - DBMS_SCHEDULER Calendaring Syntax -

i new dbms_scheduler and, after reading oracle's documentation, wondering if check syntax repeat interval?

daily, @ 3am

freq=daily;byhour=3

sundays, @ 3am

freq=weekly;byday=sun;byhour=3

beginning of month, @ 3am

freq=monthly;bymonthday=1;byhour=3

quarterly (beginning of jan, apr, jul, oct), @ 3am

freq=yearly;bydate=0101,0401,0701,1001;byhour=3

annually, on 1st aug, @ 3am

freq=yearly;bydate=0801;byhour=3

your intervals vague, , may not start when expect.

e.g lets ran dbms_scheduler.create_job @ 16:09:12. repeat interval of freq=daily;byhour=3 mean job start @ 03:09:12 next day. in effect got asked for.

if want job start @ 3am sharp,

freq=daily;byhour=3; byminute=0; bysecond=0;

the same goes of examples. whilst have ok, accurate hr , oracle pick min , sec submission time.

oracle syntax scheduler