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.
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:
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?