Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER.CREATE_WINDOW Duration

edited Jul 20, 2020 11:27AM in Database Administration (MOSC) 5 commentsAnswered

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;

/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center