Agree with Rene but keep in mind by using that query for a high load system will reduce the speed since there will be overhead.
sangprabv [email protected] On Jun 21, 2010, at 12:41 AM, Rene Kluwen wrote: > Yes, sqlbox does scheduling of writing with a simple (1-line) patch. > > You can find it on the mailinglist, but to facilitate your search, here it is > again: > > 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" > > > == Rene > > From: [email protected] [mailto:[email protected]] On Behalf Of > sangprabv > Sent: zondag 20 juni 2010 16:04 > To: T.K.Thapa > Cc: [email protected] > Subject: Re: Scheduling Question > > Quick and dirty way is patch the query in the sqlbox source code. > > > > sangprabv > [email protected] > > > > On Jun 20, 2010, at 4:15 PM, T.K.Thapa wrote: > > > Hello, > > Does kannel bearerbox,smsbox or sqlbox support scheduling of messages? If yes > how? > > Regards > Tapan Thapa > >
