Aug 25, 2006 09:40
My employer is having one of its 'moments'. The IT guys have decided to rename several tables on our data warehouse this weekend. Woo! Da Boss admittedly forgot to pass the information along when it was given to him, but he still only had a week's notice. Er, I now have a day's notice to go through a number of my auto trackers and fix them so that they don't break on Monday. The warehouse will also be down over the weekend while they make the changes, so it's a darned good thing we won't be in on the Bank Holiday! Instead, we're scheduling all the Monday trackers to run on Monday evening so we'll still have the data on Tuesday ready to go. Hopefully. If we get all the table names changed correctly.
Unfortunately, they don't have the new tables set up yet to test the table names on. Darn. And we've already found two typos in the document listing the old table names, so I'm not entirely convinced that they've got the new table names correct.
Thank goodness I have a three day weekend ahead so that I can rest up properly for this mess :-)
I have a cup of tea at hand, I'm armed with a (probably incorrect) reference document and we've got just seven hours to change a dozen trackers (there's two of us working on this) without the ability to test our changes. I'm suddenly getting the Challenge Anika theme music in my head...
Woot!
it fun,
coding,
work crap