The list of future scheduled run times for a job shows the dates and times that a job will run, but it doesn't tell you which time zone that time is in.
If there's a scheduled job that was created while in BST (British Summer Time) and was set to run at 04:00 with:
start_date => TO_TIMESTAMP_TZ('2015/01/01 04:00:00 +01:00','yyyy/mm/dd hh24:mi:ss tzr')
repeat_interval => 'FREQ=DAILY;BYHOUR=04;BYMINUTE=00;BYSECOND=0'
Therefore, during BST, the job runs at 04:00 local time.
When in UTC (Coordinated Universal Time) (+00:00), the job still runs at 04:00 +01:00 which is 03:00 local time.
This is how Oracle functions, but the "Schema Browser | Scheduler Jobs | Scheduled Run Times" doesn't display this properly. It always shows the run times as "04:00" - and doesn't show what time zone this is. The format string that displays this needs to include something like the TZR (time zone region) element. The "Run Log" tab does format the times properly.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center