Robert, For something like this, I generally have a scheduled task for a given application that executes every 5 minutes (or whatever is appropriate). When it executes, it queries a datatable of tasks that need to be executed. This table can be updated manually or be data-driven (as it sounds like yours is).
Usually, the table will have something like: date_last_executed date_next_executed meta_data is_active Then, I query for tasks where the taks is_active = 1 and date_next_executed < Now(). Does that help? On Mon, Apr 6, 2009 at 3:07 PM, Robert Harrison <[email protected]>wrote: > > I need to write a routine that executes various actions based on user > entered dates/times. The dates/times to act would be listed in a data > base. > > I really don't see a way to use the Scheduled Tasks page for this as that > seems more in tune to batch processing type stuff. The only way I can > think > of doing this is to write a never ending program that keeps checking to see > if an action is ready to kick off. > > Is there a better way to handle this? > > Thanks > > > Robert B. Harrison > Director of Interactive Services > Austin & Williams > 125 Kennedy Drive, Suite 100 > Hauppauge NY 11788 > P : 631.231.6600 Ext. 119 > F : 631.434.7022 > http://www.austin-williams.com > > Great advertising can't be either/or. It must be &. > > Plug in to our blog: A&W Unplugged > http://www.austin-williams.com/unplugged > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
