Question
Schedule and Mail
I want to use
CFScheduler tag in MX 7 on Windows 2000 to send out about
100 emails once a week at a specific time. The disctinct email
addresses are taken from a query from an Access 2003 database.
Two questions:
1- What if one or some of the 100 email addresses are not valid.
I do an data check for email validations so all the database emails have correct email syntax. But maybe there could be addresses that are not valid and the CFMail will not be able to send. Will the "dead" emails go to the Server deposit area or do anything to the other Email sends??
2- I want to make sure the CFScheduler sends at the exact time specified. Is this the correct way to do it and is the cfschedule tag 100% accurate where I can depend on it to run once a week and never run more than once a week?
<cfif DayofWeekAsString(DayOfWeek(Now())) EQ 'Friday' and Timeformat(Now(), 'hh:mm tt') EQ '12:25 PM'>
<cfschedule action = "update"
task = "SendEmails"
operation = "HTTPRequest"
url = " http://myServer/mydirectory/sendEmails.cfm"
startDate = "5/11/07"
startTime = "12:25 PM"
interval = "weekly"
path = "c:\inetpub\wwwroot\mydirectory"
requestTimeOut = "600">
</cfif>
SendEmails.cfm with Date and Time condition:
<cfif DayofWeekAsString(DayOfWeek(Now())) EQ 'Friday' and Timeformat(Now(), 'hh:mm tt') EQ '12:25 PM'>
...etc...
....etc...
</cfif>
Two questions:
1- What if one or some of the 100 email addresses are not valid.
I do an data check for email validations so all the database emails have correct email syntax. But maybe there could be addresses that are not valid and the CFMail will not be able to send. Will the "dead" emails go to the Server deposit area or do anything to the other Email sends??
2- I want to make sure the CFScheduler sends at the exact time specified. Is this the correct way to do it and is the cfschedule tag 100% accurate where I can depend on it to run once a week and never run more than once a week?
<cfif DayofWeekAsString(DayOfWeek(Now())) EQ 'Friday' and Timeformat(Now(), 'hh:mm tt') EQ '12:25 PM'>
<cfschedule action = "update"
task = "SendEmails"
operation = "HTTPRequest"
url = " http://myServer/mydirectory/sendEmails.cfm"
startDate = "5/11/07"
startTime = "12:25 PM"
interval = "weekly"
path = "c:\inetpub\wwwroot\mydirectory"
requestTimeOut = "600">
</cfif>
SendEmails.cfm with Date and Time condition:
<cfif DayofWeekAsString(DayOfWeek(Now())) EQ 'Friday' and Timeformat(Now(), 'hh:mm tt') EQ '12:25 PM'>
...etc...
....etc...
</cfif>
AdChoices