I am developing an asp.net Website which is connected with SQL database, SQL database has two columns START_DATE and END_DATE, so I want if END_DATE is greater than START_DATE then it send a mail automatically even when the website is not in use..
我正在开发一个与SQL数据库连接的asp.net网站,SQL数据库有两列START_DATE和END_DATE,所以我想如果END_DATE大于START_DATE,那么即使网站没有使用它也会自动发送邮件。
Thanks in Advance..
提前致谢..
1 个解决方案
#1
Two possible paths:
两条可能的途径:
-
Create a job in your SQL server to monitor the table and send emails when you want.
在SQL Server中创建一个作业来监视表并在需要时发送电子邮件。
-
Create a windows service which queries the table every so often to see if an email needs to be sent.
创建一个Windows服务,每隔一段时间查询一次该表,以查看是否需要发送电子邮件。
#1
Two possible paths:
两条可能的途径:
-
Create a job in your SQL server to monitor the table and send emails when you want.
在SQL Server中创建一个作业来监视表并在需要时发送电子邮件。
-
Create a windows service which queries the table every so often to see if an email needs to be sent.
创建一个Windows服务,每隔一段时间查询一次该表,以查看是否需要发送电子邮件。