This content has been marked as final. Show 8 replies
Have you considered using CFSCHEDULE?
Just out of curiosity what cf server version are you using? We send out thousands of emails (using spooling) without much problem at all with MX 7.0.2.
Other than that I wouldn't do a cflocation back to yourself.
you can put the entire processing in a loop and make it go to sleep for 10 minutes until all the emails are sent instead.
This way you have one thread running and sleeping at 10 minute intervals but you will need to make sure that you have a way of determining if the email has been sent so you can start again if something bad happens :)
cfchedule <smacking forehead!> I'd totally forgot about it. Very cool. I can schedule a task to run until it completes and then delete it when done. Perfect.
The probelm is I have to relay the email from the CF server out through our corporate email server and thats the one clogging up.
cfschedule looks perfect though.
IIRC there was a bug involving deleting scheduled tasks. I do not remember where I read it. You may want to do some searching first.
I'll keep searching on this but all I could find regarding ver 7 is an esoteric bug regarding clustered servers.
There were bug complaints from earlier versions but so far so good. The proof will be in the testing once I get this going.
I finally found it. The issue I read about was with tasks deleting themselves. It applied to MX6, but I do not know if it was ever fixed in MX7. Here are the links in case it applies to what you are doing.
Mike Schierberl's Blog: cfschedule delete - workaround (from google cache)
ColdFusion MX: Deleted scheduled tasks continue to run
That totally stinks!! It's the prefect solution. Well there's one way to find out, I will test the heck out of it and report back. Not today though as I woke with a bad back and am staying home.
Thanks so much for finding the reference, now I know what to look for - I really appreciate it!!