Do I need to worry about British Summer Time ?
As an example a simple 3 program chain job using a set up schedule which is set to run at 10:00 and 16:00 hours daily Mon-Sat
[repeat_interval => 'FREQ=daily; BYHOUR=10,16; BYDAY=mon,tue,wed,thu,fri,sat']
The default timezone is currently set to Europe/London.
Schedule start_time is set to TRUNC(systimestamp).
I would expect and want the job to kick off at the next instance of 10:00; then at 16:00 with this frequency being repeated daily whether we are in BST or not.
Based upon the above default_timezone and start_date settings, will the job run at 11:00 and 17:00 in BST (April to October) and revert to 10:00 and 16:00 (November to March) ?
If so, what are the default timesone settings to use and the correct start date
[E.G.: TRUNC(systimestamp); dbms_scheduler.stime() or something like To_TIMESTAMP_TZ('04-OCT-2010 10:00:00','DD-MON-YYYY HH24:MI:SS') ] which will allow the job to run correctly at 10:00 and 16:00 ?
Also what would happen to jobs which run over the changeover times from BST to non BST ?
Any help would be appreciated.