G'day Rick, There are two ways I could think of to do it
[A] make one task, that in turn calls all the others, one after the other. Perhaps with some logic in each to ensure the previous task completed successfully, if that's appropriate. [B] give each task an identical interval, but long enough to allow all teh others to run with a space for safety's sake, and starting at staggered times. e.g.: task 1, every 5 minutes, starting at 10am task 2, every 5 minutes starting at 10:02am task 3, every 5 minutes, starting at 10:03am task 4, every 5 minutes, starting at 10:06am etc. The start time would be based on teh average length of time the previous task runs, plus a margin to ensure the task starts after the previous one is finished. Of the two, I prefer [A]. The other method relies on everything happening properly and if something goes wrong, your sequence will go haywire. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, May 25, 2008 at 10:33 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Hi, all... > > Yes, I'm having to work this Memorial Day weekend to meet > some deadlines. > > I need to set up a series of scheduled tasks and insure that > they run consecutively. In other words, I need to make sure that > each one completes before the next one starts. > > What's the best approach for that? > > I hesitate to put all the tasks (a series of queries, actually) in > one large file, preferring to let the server run separate tasks...but > perhaps with a pause routine in between the queries it wouldn't matter? > > Thanks for any advice. > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
