Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
sp_TopicIcon
Scheduled column?
sp_NewPost Add Reply sp_NewTopic Add Topic
March 23, 2014
2:20 pm
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

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
Sikandar
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

Hi,
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)

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488