使用数据库调度将邮件发送给其他用户 [英] Send a mail to different user using database scheduling

问题描述

如何向他人发送邮件给他们的电子邮件ID，数据库中的数据会在每个季度的中间自动发送到数据库安排



请帮我解决这个问题





谢谢和问候

Spoorthi GS



我的尝试：



我已经尝试过做数据库调度但我无法实现它

Hi,

How Can i send a mail to different user for their email ids , the data that are present in the database automatically for middle of each quarterly through database scheduling

Please help me out to resolve this problem


Thanks and Regards
Spoorthi G S

What I have tried:

I have tried it doing database scheduling but i am unable to achieve it

推荐答案

您需要使用Windows Scheduler通过应用层发送电子邮件。意味着您需要创建一个.exe文件并执行计划基础（每季度）。以下是步骤：



Step1 ：创建一个控制台应用程序并实现您的逻辑以从MySql数据库获取数据并向用户发送电子邮件。完成实现后，您需要构建并获取.exe文件。



Step2 ：接下来在您的服务器中创建一个调度程序并在调度程序中引用该.exe文件。然后它将执行间隔基础（季度）。通过以下链接可以帮助您：



Windows Scheduler with C＃ [ ^ ]

You need to send emails through application layer using Windows Scheduler. Means you need to create a .exe file and that will execute schedule basis(quarterly). Here is steps:

Step1: Create a console application and implement your logic to fetch data from MySql database and send e-mail to users. Once you are done with implementation you need to build and get the .exe file.

Step2: Next to create a scheduler in your server and refer that .exe file in scheduler. Then it will execute interval basis(quarterly). Go through below link that may help you:

Windows Scheduler with C#[^]

这篇关于使用数据库调度将邮件发送给其他用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！