The link's objective is about priority not scheduling a message, and it will cause overhead to your MySQL. I prefer do it via application layer. The simplest way is to add the 3rd table (currently sqlbox has send_sms, sent_sms) we can call it scheduled_sms. Develop a simple application which function is to copy scheduled_sms records to send_sms table. You can play with your query here, such as limiting the timestamp. Setup a crontab that will execute that application. And you done :)
On Aug 3, 2012, at 12:13 AM, spameden wrote: > Yes, you can do this, but you need to modify source of Sqlbox > (gw/sqlbox_mysql.h there is a query) or do it on Application level as Willy > suggested. > > http://stackoverflow.com/questions/8458566/implementing-priority-queue-in-kannel > > 2012/8/2 Willy Mularto <[email protected]> > do it in application level. > > > > On Aug 2, 2012, at 11:11 PM, neo nortan wrote: > >> dear list >> >> can i schedule delivery of sms. >> i am using sqlbox in kannel >> >> regards >> >> >> >> >> Follow Rediff Deal ho jaye! to get exciting offers in your city everyday. > > Willy Mularto > F300HD+MR18DE (NLC1725) > > > > > > > > > > Willy Mularto F300HD+MR18DE (NLC1725)
