>When the job is complete, the RESET_ALL call, re-instates no only the properties of a number of tables but also, where appropriate, the original relationship just as it was. It then disappears without a trace.

It's amazing the things we have to do to get the job done....
(I hope you documented that logic so you can make sense of it later)