I understand what you mean here, but I linked this just to show how you can similarly solve this problem.
The problem with crontab - it gets executed not right after (or you would need to setup a cron which runs every second - not really good solution imo). I think the best way is to manage a queue inside the database with priorities and timestamps. So, for example, if you restart kannel or something goes wrong it's all inside your database and after kannel starts it will continue processing the queue. About 2 or more send_sms tables - well, yes, we are using multiple SQLBox-es so far it works ok, but I do not know how can you load balance between them? i.e. let's say you have sqlbox1, sqlbox2, sqlbox3, sqlbox4 let's say user1 wants to send 1000 MT through sqlbox1 user2 wants to send 10000 MT through sqlbox2 user3 wants to send 100000 MT through sqlbox3 and on sqlbox3 you need to immediately send MT's you have 1 SMSC link. The question is: how can you balance between sqlbox-es? The only way to do this via kannel is to use priority field I guess (without altering queries). It's all bit offtopic I know, but it could be useful for someone else I think :) 2012/8/3 Willy Mularto <[email protected]> > 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 >> >> >> >> >> <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. >> >> >> Willy Mularto >> F300HD+MR18DE (NLC1725) >> >> >> >> >> >> >> >> >> >> > > Willy Mularto > F300HD+MR18DE (NLC1725) > > > > > > > > > >
