Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER Job start delayed by 10 minutes

edited Aug 2, 2011 7:51PM in Database Administration (MOSC) 3 commentsAnswered
Hi all,
I had a job created with dbms_scheduler. and I put it under a window - the scripts:

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_SCHEDULE
    (
      schedule_name    => 'SCH_SYNC_G028_DCHO'
     ,start_date       => TO_TIMESTAMP_TZ('2011/07/19 14:05:54.232734 +07:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')
     ,repeat_interval  => 'FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN; BYHOUR=3; byminute=0;'
     ,end_date         => NULL
     ,comments         => 'Runs every day at 3:00 AM'
    );
END;
/

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_WINDOW
    (
       window_name     => 'SCH_SYNC_G028_DCHO_WIN'
      ,schedule_name   => 'DCG028.SCH_SYNC_G028_DCHO'
      ,resource_plan   => NULL
      ,duration        => to_dsInterval('+000 00:30:00')

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