Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

scheduler jobs - DST

792290Mar 11 2013 — edited Mar 11 2013
I 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2013
Added on Mar 11 2013
7 comments
314 views