DBMS_SCHEDULER Job start delayed by 10 minutes
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')
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')
0