So I'm trying to get a job to run every morning at exactly 5:59:
BEGIN
sys.dbms_scheduler.set_attribute( name => '"xxxx"."test_sched"', attribute => 'repeat_interval', value => 'FREQ=DAILY;BYTIME=055900');
END;
But I get this:
Error report:
ORA-27419: unable to determine valid execution date from repeat interval
ORA-06512: at "SYS.DBMS_ISCHED", line 4648
ORA-06512: at "SYS.DBMS_SCHEDULER", line 3052
ORA-06512: at line 2
27419. 00000 - "unable to determine valid execution date from repeat interval"
*Cause: The specified repeat interval contained conflicting clauses that
made it impossible to ever find a matching date, e.g.,
'FREQ=YEARLY;BYMONTH=FEB;BYMONTHDAY=31'. Alternatively,
the scheduler reached its maximum number of attempts to try to
find a valid execution date. This occurs when theoretically
there is a valid execution date far in the future, but the
scheduler took too many attempts to determine this date.
*Action: Remove the conflicting clauses, or simplify the repeat interval
so that it is easier to determine the next execution date.
Setting the 'BYTIME' variable to '050200' or '050100' works but '050300' and '055900' do not.
What am I missing?