Reply to post:

Another day, another British Airways systems screwup causes chaos

Anonymous Coward
Anonymous Coward

As databases like Oracle and SQL Server started using TIMESTAMP WITH TIMEZEONE data types instead of the basic date datatypes, more of the older DB developers got very confused and spent days trying to fathom out why jobs wouldn't run at the time they specified not realising about the use of daylight savings in relation to TWT and schedulers.

Once found a system that would fail to run ultra-critical jobs at exactly 2 points during the year. Found out some muppet set the time to run at the exact moment the clocks skip the hour as they change, the scheduler wasn't intelligent enough to know and it just skipped all the system critical jobs.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon