Remote Notification to Mobile Phone via Short Message Service
February 7, 2000
[SQL Server Version 6.5] [SQL Server Version 7.0] An alternative for Pager Notifications for Operaters can be accomplished using Text Messaging on a mobile phone. This option can be simple and free to implement as it does not require third-party software, just an EMail-SMS service provider .
Unfortunately while developing this method I have only found UK based EMail-SMS service providers. While I realise that this will restrictive, some people should find it useful and hopefully someone may know of other EMail-SMS service providers in other countries that can be included within the article.
The remote notification is accomplished by sending SQL Mail messages to an email address that will route the message to a mobile phone as a text message.
Creation of a Routing Email account:
Register an account with the following steps:
I suggest that you test the email address once it has been set up (e.g. send an email with the current time). The email should only take a few minutes to reach the handset.
Set up a Rule with the following steps:
The installation assumes that SQL Mail is already operating on the SQL Server. If this is not the case the following articles should assist in setting-up of SQL Mail:
Configuration of SQL Mail on Local NT Post Office
SQL Mail with SQL Server 6.5
The installation also assumes that Operators have been set up for both the SQL Server and the mail client.
Microsoft Outlook is the only mail client that I have used so far. Microsoft Exchange client does not appear to support mail forwarding through rules. Any other clients that do please inform me this article can be updated.