您可以创建Windows服务，该服务将每天检查一次，如有必要，请发送电子邮件.
或从SQL Server进行检查
http://msdn.microsoft.com/en-us/library/ms191439％28v = sql.105％29.aspx [ ^ ]
并从中发送电子邮件:
SQL SERVER-2008-配置数据库邮件-从SQL数据库发送电子邮件 [ ^ ]

或者，您可以创建从任务计划程序执行的Wcf服务.
或其他不同的东西.这取决于您想要什么.

You can create windows service which will be checking for that once a day an sending email if necessary.
Or checking this from SQL server
http://msdn.microsoft.com/en-us/library/ms191439%28v=sql.105%29.aspx[^]
and sending emails from it:
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database[^]

Or you can create Wcf service executed from Task Scheduler.
Or something different. It depends what you want.