How to send a success or failure alert to cell phones

Question

Hi

we are planning to implement that to send a success or failure alert of sql server agent to cell phones.

I am unaware of how to configure and not getting root. Can someone please give us the description or some recommended suggessions.

 

 

 

---

Regards; Sureddy; Database Administrator

Answer 1

Hi Sureddy,

Could you please elaborate a bit? Which version of SQL Server are you using? What’s the form of the alert? Do you want to send SMS notifications to cell phones from SQL Server? Sending SMS notifications is not supported by SQL Server, please see:

How to: Notify an Operator of Job Status (SQL Server Management Studio)
http://msdn.microsoft.com/en-us/library/ms191130.aspx

Job Properties / New Job (Notifications Page)
http://msdn.microsoft.com/en-us/library/ms189685.aspx

I think you can try running a query to find those failed jobs and then create a CLR stored procedure that communicates with the SMS gateway to send SMS.

You may refer to:

http://sqlserverpedia.com/wiki/SQL_Server_Agent_Job_Query_Samples

http://geekswithblogs.net/rajap/archive/2009/08/04/implementing-sql-clr-triggers.aspx

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.