SQL Server Performance Forum – Threads Archive
Sending SMS messagesHi guys, I have created a job in SQL 2000, it basically inserts data from Sever A to Server B, as it runs in the weekend, i was thinking to include alert message. for example if job fails to insert a record it should send an SMS Message to my mobile. Is this possible..? Your help is much appreciated Whenever you fall, pick something up.
You have to setup the Exchange server in order to send those alerts to relevant mobile devices.
Also checkhttp://www.web2sms.f2s.com/ in this case for a SMS gateway API to setup, refer to the books online in order to setup such alerts to use the MAPI profile Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.