There's an awful lot of stuff written out there about this topic, so this will be relatively brief. However, none of the posts I'll be linking to answered my question or solved my problem, that's why I'm putting this here. DST ended in the UK on Sunday 26th October with the clocks going back one hour. From that point on, my audit log purge job, which runs daily through DBMS_SCHEDULER has been running an hour early! I wouldn't normally have noticed as it runs in a quiet time but I happened to be looking at some other logs and spotted it wasn't right. The Oracle DBMS_SCHEDULER docs seem to have the information to sort this out: Repeating jobs with frequencies smaller than daily follow their frequencies exactly across daylight savings adjustments. For example, suppose that a job is scheduled to repeat every 3 hours, the clock is moved forward from 1:00 a.m. to 2:00 a.m., and the last time the job ran was midnight. Its next scheduled time will be 4:00 a.m. ...
Comments
Post a Comment