I also just thought of something. I am using the following setting; Frequency: Daily every 12 hours start time: 11:00 PM. Do I need to specify End time too?
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? > > > On Thu, Nov 12, 2009 at 6:25 PM, Maureen <[email protected]> wrote: > >> >> Is there any chance the morning run is conflicting with another task, >> like a backup, or another import, and just stalling? >> >> On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi <[email protected]> wrote: >> > >> > Yup. that's what I am doing now. CFTransaction is an option but it won't >> do >> > me any good if for some reason the processing just stops without any >> error. >> > It is strange but that's what's happening. I haven't found any errors in >> the >> > logs. Also, it gets more interesting as the task runs every 12 hours. >> the >> > one that runs in the evening is fine and the one running in the morning >> has >> > started to not run after deleting records from two tables. I am also >> going >> > to start writing each row's insert/update success to a log file to see >> > exactly what's going on. >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
