This is from an old post from Emmanuel Chanson:

 

>in gw/sqlbox_mysql.h

>  something like:

>  SELECT sql_id, momt, sender, receiver, udhdata, \

>msgdata, time, smsc_id, service, account, id, sms_type, mclass, mwi, coding, \

>compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, \

>charset, boxc_id, binfo, meta_data FROM %S WHERE time < UNIX_TIMESTAMP(NOW()) 
>LIMIT 0,1"

 

 

Having done that, you can just insert a valid time in the “time” field and 
sqlbox will automatically send the sms at the desired time.

 

== Rene

 

 

From: [email protected] [mailto:[email protected]] On 
Behalf Of neo nortan
Sent: Thursday, 02 August, 2012 18:12
To: users 
Subject: schedule delivery of sms

 

dear list 

can i schedule delivery of sms.
i am  using sqlbox in kannel

regards



 
<http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?>
 


Follow Rediff Deal ho jaye! 
<http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___&cmp=signature&lnk=rediffmailsignature&newservice=deals>
  to get exciting offers in your city everyday.

 

Reply via email to