![]() ![]() Given the phone number above and the fact that I use Verizon I'll enter in the To: field and click Send Test E-Mail, use your cell number and the gateway domain name from the table above to find your own cell phones email address. Right-click on Database Mail and select "Send a test E-mail". In Object Explorer expand the instance, then the Management tab. Open SQL Server Management Studio and connect to an instance with Database Mail configured. To ensure Database Mail can reach the gateway let's send a text email/text message. No, not really but for this tip we'll pretend it is. I am a Verizon customer and my cell number is. If your provider is not in this list or you are outside the US, then search Wikipedia for "SMS Gateway" for a more extensive list or contact your provider directly for information. Keep in mind that even though sending the message is free, the recipient is liable for charges based on their contract, if you have a run-away alert it can get very expensive! Check with your provider before you rack up a ton of text charges - you have been warned! It is a free service from most providers, but a few may charge a fee or require sign-up. This is a table listing the largest cellular providers here in the US and the domain name of the SMS gateway that will convert an email to a text message. I'm going to make the assumption that you have already setup Database Mail on your server, if not there are instructions in the Database Mail category on that will walk you through the process. ![]() The critical alerts use an operator setup to send email to the SMS gateway of our cellular provider so they can be received by the on-call DBA even when they are offline. The non-critical alerts only go to email and can sit in our inbox until someone checks. We setup two operators on each server, one for non-critical alerts and one for alerts that need immediate attention. Even those of us who have smart phones found it easier to attach a custom notification to an incoming text message than to an email. When I started developing an on-call rotation for my DBA team it quickly became apparent that for off-hours alerts we needed a way to reach team members when they were not online. It didn't seem all that useful at the time unless I had a friend who did not have texting and wanted to chat. I learned some time ago that I could send an email to my cell phone via email using a free service provided by my cellular provider. In this tip I'll show how to configure an operator that will send an email to one of these gateways. Most cellular providers who offer texting (SMS or Short Message Service) also provide a free email to SMS gateway that costs the sender nothing and the receiver pays for messages based on their text plan. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |