Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Scheduled column?
sp_NewPost Add Reply sp_NewTopic Add Topic
March 23, 2014
2:20 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Sikandar,

The first thing you should check is if the 'SMSOutScheduled' field in the advanced settings of the SQL connector is pointing to the proper field name in the database. If that is the case it should work, I have just tested this with an Oracle Express 11g database and found that it works as expected.

This function depends on the proper date format in the 'Scheduled' field and Oracle can be a bit finicky with regards to the input of date and time so be sure to enter the date to the MessageOut table in the right way. For instance with the TO_DATE function:

insert into MessageOut (MessageTo,MessageText,Scheduled) values ('1234','Example text',TO_DATE('2014/03/23 14:01:00', 'yyyy/mm/dd hh24:mi:ss'))

Regards, Henk

March 21, 2014
7:11 pm

I am inserting in MessageOut table of my Oracle db and in scheduled column '22-MAR-2014 9:59:00' while today is 21-MAR-2014 but still SMS is showing sent immediately. While my understanding is that this sms will be sent on 22-MAR-2014 9:59:00. Need assistance if I am missing something. tks

(messageto, messagefrom, messagetext, messagetype, gateway, scheduled)

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502