如何触发时间设定 [英] how to triger time setting

问题描述

大家好，

我在asp .net和C#中使用sql server 2005时遇到问题，用户以Web形式设置时间表，将短信发送到他希望的手机号码，该时间表将存储在数据库中，根据该时间表邮件应发送到指定的号码.


如何从特定的数据库表中触发sql server 2005中的时间表.


感谢所有人..

hi to all.,

i have problem in asp .net , C# with sql server 2005 that in a web form a user set the time schedule to send a text message to his wish mobile number, that time schedule will get store in database, according to that time schedule the message should get send to the assigned number.

How to make trigger that time schedule in sql server 2005 from a particular database table..?



Thanks to all..

推荐答案

您想要的是Windows服务，因为您的数据库和网站都是无状态的.需要运行服务来设置计时器以执行这些操作.

What you want is a windows service, because your DB AND your website are stateless. A service needs to run that sets timers to perform these actions.

如果我正确理解了您的问题，则可以使用SQL Agent定期检查数据库中的数据.如果需要发送消息(基于数据库中的信息)，则可以执行例如shell脚本，发送电子邮件等.

有关更多信息，请查看:创建作业 [

If I understood your question correctly, you could use SQL Agent to regularly check the data in the db. If it''s time to send a message (based on the info in the db) you could execute for example a shell script, send an email etc.

For more info, have a look at: Creating Jobs[^]

这篇关于如何触发时间设定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！