Support forum
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:
Regards, Henk
7:11 pm
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)
Most Users Ever Online: 529
Currently Online:
6 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 681
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1160
Posts: 3961
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1517