Skip to Main Content

SQL & PL/SQL

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!

dbms_scheduled job and british summer time

user5716448May 26 2020 — edited May 26 2020

Hi,

versionĀ  11.2.0.3

Have a dbms scheduled job which is set up to run at 8.05 a.m.

Get e-mail through each morning at 9.06 a.m looks like running an hour later.

Also e-mail comes through at 9.06 a.m but e-mail in outlook shows as 10.06 a.m.

26-MAY-20 09.07.58.560828 +01:00

Freq=Daily;Interval=1;ByHour=08;ByMinute=05

Couple of questions

1) How can we ensure runs at same time all year round and is not adjusting itself with bst which looks to be doing

2) I'm assuming the +01.00 is affecting the time shoing on the e-mail which suggests running at 10.05 a.m whn in actula fact running at 9.05 a.m but should really run at 8.05 a.m.

Any thoughts on how best to resolve so runs at 8.05 and shows in e-amil as 8.05 a.m. all year round.

Thanks

This post has been answered by GregV on May 26 2020
Jump to Answer
Comments
Post Details
Added on May 26 2020
6 comments
562 views