Without alot of thought .. but something you might investigate ... <cfschedule>
It will create scheduled events .. Create a master application that will do a lookup on your database and find out how many records you have .. (say 10,000). Have this master application then create 20 (20x500 = 10,000), scheduled events in the cf scheduler pointing to another application that will process your 500 rows... with say URL parameters of startrows=1, startrows=501 ect.. So at 2AM, the master app runs and creates the 20 events. ... those twenty events looks something like this: http://www.woohoo.com/events/runme.cfm?startrows=1 http://www.woohoo.com/events/runme.cfm?startrows=501 http://www.woohoo.com/events/runme.cfm?startrows=1001 ect... Oh and when you set they dynamic scheduled events, have them separated however long you want ... Dunno if that is feasible .. but just a thought! Good Luck and let us know how it goes Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder ----- Original Message ----- From: "Duane Boudreau" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 10, 2002 10:29 PM Subject: Scheduled Events > I need to accomplish the following but am not sure how: > > I have a template scheduled to run that processes records in a db in blocks > of 500. (Each record is marked as it is processed) > > After the template has processed its 500 records I would like the template > to "sleep" for two minutes and then reload itself. I don't want to use a > counter since that will eat up processor and memory. > > Any suggestions for the reload and wait? > > Thx, > Duane > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
