As a follow up to this, I tried resetting the schedule to a date in the past but sure enough Coldfusion still uses the original task settings, arrghhh!
I have now resolved (worked around) the issue. When the user sends the message it changes the status of the message to "Sending" in the db. When the scheduled task runs it grabs the message and then imports a mailing list into the db from a csv file. It then loops through the addresses to send to in batches of 300. Then once the message is sent it deletes those addresses from the db. The task then comes around again and again until their are no more addresses to send to. It then marks the message as "Sent". The task is also then updated with a start and end date of yesterday. However, coldfusion keeps running the task. But the message is marked as "Sent" and so I wrote a conditional that prevents any further action. So the task aborts. It may not be ideal and the task will keep running until the end date is reached but it will have to do until I can persuade our boss to upgrade to CFMX7 Ent. Cheers, Dave [EMAIL PROTECTED] wrote: > Dave, > > The setting the date in history could work for you, but I would have the same > concerns Micha had. What you could do, though, is write a weekly routine > that deleted tasks in the past, and schedule a CF service restart in the > middle of the night. That would clear them out weekly and keep them from > building up for a long time. Personally, I never tried setting them in the > past for this issue, but I did change some scheduled tasks end date to past > and that seemed to work, so your idea in theory sounds like it could work. > > Workarounds are always messy, but if Macromedia won't get on the ball and fix > this 2+ year old problem, then that's all we can do other than dumping CF and > moving to ASP (YECH!) or PHP (EVEN MORE YECH!). (these statements were not > meant to offend, only to express my personal opinion. ;-) > > Dave > ****************************************************************************************** > The information contained in this message, including attachments, may contain > privileged or confidential information that is intended to be delivered only > to the > person identified above. If you are not the intended recipient, or the person > responsible for delivering this message to the intended recipient, ALLTEL > requests > that you immediately notify the sender and asks that you do not read the > message or its > attachments, and that you delete them without copying or sending them to > anyone else. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213088 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54