scheduler jobs - DST
792290Mar 11 2013 — edited Mar 11 2013I have a scheduled using dbms_scheduler to which supposed to adjust according to the DayLightSavings(DST) changes
we are at US/Eastern.
here is my Job that i scheduled sometime last year.
BEGIN
DBMS_SCHEDULER.set_scheduler_attribute
(attribute => 'default_timezone',
value => 'US/Eastern');
END;
/
BEGIN
DBMS_SCHEDULER.CREATE_JOB
(JOB_NAME => 'TEST.MONTHLYORDERREP',
JOB_TYPE => 'PLSQL_BLOCK',
JOB_ACTION=> 'BEGIN TEST.MONTHLYORDERS(); END;',
START_DATE => to_timestamp_tz('2012-01-07 US/Eastern', 'YYYY-MM-DD TZR'),
REPEAT_INTERVAL=> 'FREQ=monthly; bysetpos=1; byday=TUE;BYHOUR=05; BYMINUTE=00; BYSECOND=00;',
ENABLED=>TRUE,
AUTO_DROP=>FALSE,
COMMENTS=>'Monthly Orders REPORT');
END;
/
when query the dba_scheduler_jobs the next_run_time shows as 4/2/2013 4:00:00.800000 AM -05:00. it supposed to be
4/2/2013 5:00:00.800000 AM -04:00.
when i queried the following it shows as follows:
select dbms_scheduler.stime from dual;
3/11/2013 8:28:52.780000000 AM -05:00
select dbtimezone from dual;
-04:00
can anybody help....
Thanks...