DBMS_SCHEDULER.CREATE_WINDOW Duration
Hello Here is my Window, what if the job exceeds the duration, will the job abort ?
BEGIN
DBMS_SCHEDULER.CREATE_WINDOW(
window_name => 'RI_TEST_AUTOSTAT_DAILY',
duration => NUMTODSINTERVAL(2, 'hour'),
resource_plan => 'DEFAULT_MAINTENANCE_PLAN',
repeat_interval => 'FREQ=DAILY;BYHOUR=23;BYMINUTE=0;BYSECOND=0',
comments => 'RI Daily Auto Stats');
END;
/