We have been planning to move the DBA_JOBS to DBMS_SCHEDULER jobs but unable to set the jobs working during DST time changes. This was an example Job I setup during last DST end day '06-NOV-2016' and it failed to run during the extra hour.
--Here is the script I used to create the job
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'TEST_DST',
job_type => 'PLSQL_BLOCK',
job_action => 'ADM_ERROR_LOG_PKG.INS_ROW;',
start_date => SYSTIMESTAMP AT TIME ZONE 'US/Pacific',
repeat_interval => 'FREQ=HOURLY;BYMINUTE=10;',
end_date => null,
enabled => TRUE,
comments => 'Every 10 minutes after the hour');
END;
/
Sorry about the quality of the screen, but you can clearly see in the first screen that next_run_date was set to "2:10AM -08:00" instead of "1:10 AM -08:00AM"
Could some one please help me with what am I missing?
NLS Env on the job is
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_CALENDAR='GREGORIAN' NLS_DATE_FORMAT='DD-
MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' NLS_TIME_FORMAT='HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT='DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT='HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT='DD-MON-RR HH.MI.SSXFF AM TZR' NLS_DUAL_CURRENCY='$' NLS_COMP='BINARY' NLS_LENGTH_SEMANTICS='BYTE' NLS_NCHAR_CONV_EXCP='FALSE'
Database is Oracle version 12.1.0.2.0 running on Linux x86 64-bit
Thanks in Advance.