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!

DBMS_Scheduler on daily basis

dramMar 12 2017 — edited Mar 13 2017

Hi all,

can any one look in to the below issue and suggest me where I am selecting wrong value

I created the below daily schedule to execute the job on daily basis from MON-FRI .

SCHEDULE_NAME abcd

SCHEDULE_TYPE CALENDAR

START_DATE 12-MAR-17 04.43.01.000000000 PM ASIA/CALCUTTA

REPEAT_INTERVAL FREQ=DAILY;BYTIME=164100;BYDAY=MON,TUE,WED,THU,FRI

EVENT_QUEUE_OWNER

EVENT_QUEUE_NAME

EVENT_QUEUE_AGENT

EVENT_CONDITION

FILE_WATCHER_OWNER

FILE_WATCHER_NAME

END_DATE

COMMENTS testing

when I tried to create the job by adding above calendar I am getting the below issue:(screen shot below);

ORA-27419: Unable to determine valid execution date.........

Thanks,

dram

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2017

Added on Mar 12 2017

#database-key-features, #scheduler

4 comments

2,651 views