During one of my daily ponderings about techno-life, I had a revelation: “Wouldn’t it be cool if my SQL Server could send me text messages when something critical happens?” Since I get loads of email notifications from my SQL Servers daily (I’m a full-time DBA, remember?), I wanted a way to get severe alerts sent to me in a way that got my attention quickly. The answer: SMS Gateways.
Essentially, an SMS Gateway is a network that allows direct email-to-mobile messaging. Most mobile carriers support this type of telecommunications network. Even better – it’s ISP independent! As long as my mobile carrier can support this type of integration, I’m set to go!
To set this up in SQL Server, find your carrier’s SMS Gateway from the below list and add a new SQL Agent operator. It’s really that easy! You should test the gateway first by sending a test message from an email client.
List of Carriers Supporting SMS Gateways
SQL Server Agent Properties
Happy Texting!