dsp_email_schedule start now(): {ts '2020-11-04 11:49:01'}
server now: {ts '2020-11-04 23:49:01'}
 
Query
Template: /home/adrcom/test.adreflex.com/addins/cf_register/dsp_email_schedule.cfm
Execution Time: 3.32 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT emailid,MailSubject,MailTo,MailFrom,MailMessage from crm_scheduledemail where sendflag = 0 and scheduleddate <= '2020-11-04' and scheduledtime <= '23:49'
 emailidMailSubjectMailToMailFromMailMessage
111test 1 nov 4 9:49amakraus@adreflex.comakraus@adreflex.comtest 1 nov 4 9:49am<br /> You can <a target="_blank" href="https://test.adreflex.com/addins/cf_register/act_groupunsubscribe.cfm?grid=-1&categoryid=-3&userid=4">unsubscribe</a> from this list or <a target="_blank" href="https://test.adreflex.com/index.cfm?FuseAction=UserSettings&prodgroup=cf_register&Label=My%20Profile">view</a> your profile.

dsp_email_schedule 3 to : akraus@adreflex.com dsp_email_schedule END