存储过程发送批量电子邮件 [英] Stored Procedure send bulk email

问题描述

我开发了监控设备的系统，该设备有A，B和C三类。设备有三种主要状态，即离线，空闲和在线。然后我为想要接收和发送离线设备通知的用户创建了另一个网站，根据他们在早些时候注册时的选择AB或C.



我正在使用Oracle数据库，ASP.Net用于开发



如何在设备更改为离线时订阅许多用户的电子邮件？

存储过程是很适合这个吗？

任何例子都可以提供帮助吗？

I develop system that monitoring an equipment that has 3 categories which is A , B and C. There are three main status for the equipment which is Offline , Idle and Online . Then i created another website for user who want to receive and email notification for offline equipment based on their selection A B or C when their registered earlier.

I'm using Oracle Database , ASP.Net for development

How to send email to many user that subscribe when equipment change to offline?
Is Stored Procedure is good to use for this one?
Any example can help on?

推荐答案

因此，你可以编写一个控制台应用程序来发送邮件和将其添加为 Windows任务计划程序。



在计划程序中，在一天或一周的预定义时间（或根据您的要求） ），代码将检查这些实体的状态并向注册用户发送邮件。



有意义吗？如果您有任何问题，请回复查询。

So, you can code a console application to send mails and add that as a Windows Task Scheduler.

In the scheduler, at a predefined time of the day or week (or according to your requirements), the code will check the status of those entities and send mails to the registered users.

Makes sense? Revert back with queries, if you have any.

这篇关于存储过程发送批量电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！