Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REPEATE INTERVAL in DBMS_SCHEDULER.CREATE_JOB

847526Jan 21 2016 — edited Jan 22 2016

Hi,

I have a problem with my scheduler.It needs to be scheduled ever day 7.30 AM, 11.30 AM, 15.30, 18.45 EST

Below is the script i created. but it is executing at 7:30,7:45,11:30,11:45,15:30,15:45,18:30,18:45 EST. please advise how to get this.

Begin

  DBMS_SCHEDULER.SET_ATTRIBUTE('JOB_NAME',

                              'repeat_interval',

                              'FREQ=DAILY;BYHOUR=07,11,15,18;BYMINUTE=30,30,30,45'

                             );

END;

Regards,

Phani.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2016
Added on Jan 21 2016
#database-key-features, #scheduler
4 comments
4,986 views