Wednesday, September 28, 2011 1:13 PM
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
Friday, September 30, 2011 7:07 AM
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)
Job Properties / New Job (Notifications Page)
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:
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.
- Marked As Answer by KJian_ Wednesday, October 05, 2011 5:12 AM