With 1/2 million jobs to deal with, make sure that you do this process on a local copy of the data rather than try and move all those jobs over the network. That's take forever.
_________________________
Andrew Bates