通过 SQL Server 发送短信 [英] Text message via SQL Server

问题描述

我们的生产系统中有一些至关重要的工作.我们收到有关工作状态成功或失败的电子邮件，我们还想设置从 SQL Server 发送短信.我搜索过，但看起来不太可能，有人试过吗?

解决方案

我很久以前就使用第三方工具完成了这项工作，该工具可提供您所需要的功能.您可以在

不过，因为是第三方工具，不是开源的，不知道会不会适合你.我不知道有任何用于相同目的的免费工具.

We have some to critical jobs in our production system. We receiving email about of job status succeded or failed and also we want to set send text message from SQL Server. I searched but looks not so possible, has anybody tried before ?

解决方案

I have done this a long time ago using a third-party tool that offers exactly what you need. You can find out more about it here. And here you can find detailed information on how to send and receive messages from SQL Server, using this tool.

In the website it is stated that you can only use this for free for the first 30 days.

Basically you will need to host their small database on your SQL Server and then insert a row into a Messages table with the message you want to send along with the phone number to which it has to be delivered.

"The SMS Messaging Server service application will pickup any newly added messages and send them out through the appropriate channel automatically." as stated in the documentation.

However, because it is a third party tool and not open source, I don't know if it will be suitable for you. I am not aware of any free tools for the same purpose.

这篇关于通过 SQL Server 发送短信的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！