DBMS_SCHEDULER or DBMS_JOB And DST / Timezones Explained
(Doc ID 467722.1)
Last updated on FEBRUARY 03, 2019
Oracle Database - Standard Edition - Version 220.127.116.11 and later Oracle Database - Enterprise Edition - Version 18.104.22.168 and later Information in this document applies to any platform.
*** Checked for relevance on 5-Apr-2016 ***
This note gives an overview of how DBMS_SCHEDULER / DBMS_JOB reacts on Daylight Saving Time( DST ) transitions and what to know when using timezone information with jobs.
To be used when DBMS_SCHEDULER / DBMS_JOB jobs run at a wrong time after a DST change or you have output from jobs selecting from TIMESTAMP WITH LOCAL TIMEZONE columns that is not correct. If things about timezones are not clear please have first a look at <Note 340512.1> Timestamps & time zones - Frequently Asked Questions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!