Hi Ballard Firstly, thanks for your reply.. I manage a digital marketing platform. At the moment, I use SAS CI Studio to send bulk SMS's (Text messages) to a pre-defined list of customers that are uniquely identified by the Customer_ID. At the moment I manually query a SQL Server table (SMS reply table) paste the result into an excel spreadsheet and sort through the responses to isolate the customers that indicated they want to take the product offered. This subset of customers are then loaded into a mainframe architecture which we use as our 'billing' system. What i would like to do is automate the checking of the reply table, which i currently do at perhaps 5 hour intervals daily. Manually recording the last received datetime stamp and using that as my starting point for the next time I check through the replies so as not to select a duplicate customer. My idea is to somehow automate the monitoring of the reply table and select appropriate responses and output the selection in the required format to a desired location for automatic absorption by the billing system (which at this moment is a .txt file) The values I refereed to in my first piece (12:00:00 to 12:00:30) was an example of the time stamp, meaning from 12h00 to say 12h05 store those responses and then start reading replies again from 12h05 and 1 second? Hope this makes sense?
... View more