从到期月份之前发送的电子邮件提醒 [英] Sent email alert before month from expiry

问题描述

你好，我有表格gridview与col许可证到期日期，我希望从到期后30天发送到特定人员的电子邮件，并在电子邮件正文中应该有链接重定向所有许可证到期的页面。





**我使用的是sql数据库



我尝试了什么：



我使用sql代理，Quartz，Windows服务搜索了一些方法，你需要创建带有计划和触发器的作业。 />


但是有些人可以给我最简单和最好的方法来解决我的问题而我不能使用sql代理因为sql版本不支持它而且（给我一些提示提示开始）



或者只是帮我这个，我将不胜感激

hello, i have table gridview with col license expiry date and i want befor 30 days from expire send to a specific people email , and in email body should have link to redirect the page that have all licenses expiry.


**i am using sql database

What I have tried:

i've searched too long some method using sql agent, Quartz, Windows service and u need to create jobs with scheduled and trigger.

but can some just give me the simplest and best method for my problem and i can't use sql agent because of sql version don't support it and (give me some hint-tips to start with )

or just help me with this and i will be appreciated

推荐答案

最简单，最好不要总是一起去。



最简单，手动完成。这样就没有代码可以写了。



就个人而言，我会考虑创建一个控制台应用程序来查询数据，进行比较，创建电子邮件，以及发送。然后使用Windows计划程序安排控制台应用程序在您希望的时候运行。

Simplest and best do not always go together.

The simplest, do it manually. That way there is no code to write at all.

Personally I would look at creating a console app to query your data, do the comparison, create the email, and send it. Then use the Windows Scheduler to schedule the console app to run when you would like it to.

这篇关于从到期月份之前发送的电子邮件提醒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！