I have read other posts about cfscheduler, but I can't get my arms around it in terms of what I am trying to do.
We have a newsletter that we want to send out on a dynamic schedule. The flow of the tasks looks like this:
1. Page 1 shows a list of available groups that people are part of in a db table. (ie FirstName Bob, Group Plumbers, EAdd email@example.com) The user clicks the checkboxes in front of each group that they want to send the newsletter to and clicks next.
2. Page 2 shows the user a bunch of textboxes and textareas in which they type their new information for this newsletter. These fields are stored in a db also.
3. Page 3 allows the user to preview the newsletter and click on send to do a cfloop through the email addresses that belong to the groups selected and send out the email.
I can do this much. My problem is, how do I schedule the actual send to not happen until a specified time/date? Would the best way be to store the time and date to send the newsletter in the db and then have a cfscheduler run a cfm file hourly which contains a sql statement checking to see if there are any newsletters that are available since the last time the scheduler ran?
I am basically thinking out loud, so feel free to tell me that the whole thing is wrong and that there is a better way to do it if that is the case.