jlcox
Member³
There are some available options for the repeat interval for a schedule which do not appear in the UI for Schedule properties.
Example:
'exclude' and 'bysetpos' are valid for this schedule, but do not appear in the UI (or displayed via View SQL).
Worse, if a schedule like this is edited in the UI, those options will be removed from the existing schedule without warning.
Sorry that I didn't report this during beta, just discovered this today.
Example:
Code:
DBMS_SCHEDULER.CREATE_SCHEDULE
(schedule_name => 'SCHD_2008_1ST_WK_DAY_EACH_MTH'
,start_date => to_timestamp_tz('01/01/2008 00:00:00','dd/mm/yyyy hh24:mi:ss')
,end_date => to_timestamp_tz('31/12/2008 23:59:59','dd/mm/yyyy hh24:mi:ss')
,repeat_interval =>
'freq=MONTHLY;
byday=MON,TUE,WED,THU,FRI;
exclude=SCHD_2008_PUBLIC_HOLIDAYS;
bysetpos=1'
,comments => 'Run on 1st working day every month'
);'exclude' and 'bysetpos' are valid for this schedule, but do not appear in the UI (or displayed via View SQL).
Worse, if a schedule like this is edited in the UI, those options will be removed from the existing schedule without warning.
Sorry that I didn't report this during beta, just discovered this today.
