Thanks everyone for your ideas. On this idea Bryan has, it makes sense (as do the others as well). I'm guessing what I would do here is that the last task of the day would basically send to everyone who didn't get it. That way I don't leave anyone out.
So say I took my subscriber count, divided it by 96 (24*4), and ran the task every 15 minutes. I would just do a SELECT TOP (howmanytoget)... where mail_sent = 0 with the SQL and then if the time the task is running is 15 minutes or less from midnight, I would do a regular select where mail_sent = 0 (without the top) to ensure I've gotten everyone else that's left over (since the math won't be 100% accurate because the list is dynamic and changes size throughout the day). Sound like it will work? Any other feedback? I'm going to start working on it and will continue to look here for comments. Thanks everyone! Sincerely, Dave Phillips BizBreeze.com [EMAIL PROTECTED] 615-746-3851 -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 1:43 PM To: CF-Talk Subject: Re: Need Suggestions for Spreading Out Notification Mailings Easy like pie ;-) 1) schedule a task to run at the desired intervals 2) task checks for all members that haven't yet recieved todays mailing 3) send mail to the first X members that have yet to get todays mailing 4) update the flag for those getting sent the mailing 5) clear out all flags at midnight and stat fresh So you'll need to alter you tables to contain a boolean (yes/no) column (called Mail_Sent). You'll also need to pick a decent interval (not so close that the first task has time to complete). To pick the number of folks to send to at each interval I'd do some simple math...total number of members divided by number of intervals gives you number to send each interval (you can do this dynamically of course as your membership fluctuates). That's the broad brush stroke for ya...hope it helps Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com/54 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184466 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
