nope, the other tasks don't do anything to those tables. so here's what I did.
wrapped cftransaction around the process. created two staging tables that hold the process updates. once the process finishes, i call a stored proc, which deletes old data from prod tables, copy data from staging to prod tables and truncates staging tables. This is working without crashing and the web site doesn't lose any data while the import job is running. thanks everyone for pitching in. that's why i love this list and rejoined after 3 years of absence. :) On Fri, Nov 13, 2009 at 4:18 PM, Maureen <[email protected]> wrote: > > Do any of the other tasks use the tables you are deleting or updating? > > On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi <[email protected]> wrote: > > > > there are other tasks that run at the same time too but none that would > > interact with the same tables. One thing I did notice though that there > is > > only one task that runs at 8:00 PM (which is this one) and there are 4 > > different tasks that run at 8:00 AM (including this task). Could that be > an > > issue? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
