SQL需要按照表中提到的日期发送邮件 [英] SQL Needs to Send a mail as per the date mentioned in Table

问题描述

Hello All，



这是我在CODE PROJECT中的第一篇文章，也是C＃.net的新手（但我有C ++和VB知识）。并开始学习关于c＃和SQL服务器



我正在创建工作分配和TAT系统，（我们从客户那里收到每个请求的工作单唯一身份证，票务结束时间）



i刚创建了从我的电脑导入excel并将数据存储到SQL服务器的Windows窗体（表名：W_Allocation）。这个表有每个请求的TAT开始时间，结束时间和Ticket状态。



我期待你的人是SQL需要发送邮件给我如果票证状态未决，则在TAT结束时间的2小时之前



有人说SQL Jobs可以做到这一点。但我有基本的SQL知识，我不知道如何从Windows窗体编程创建SQL作业。



或者还有其他方法可以做到这一点，期待你的回复，



此致，

Sathish.K

Hello All,

This is my 1st post in CODE PROJECT and new to C#.net(But i have Knowledge in C++ and VB).and started learning about c# and SQL server

I''m creating work allocation and TAT system, (we receive the Job tickets from customer each request has unique id,ticket tat end time )

i just created the windows form that import the excel from my pc and stores the data into SQL server(Table name:W_Allocation).this table have TAT start time,end time and Ticket status for each request.

What i''m expecting from you people is SQL needs to send a mail to me before 2 hour of TAT end time if the ticket status is pending

Someone said SQL Jobs can do this . But i have basic Knowledge in SQL and i dont know how to create SQL jobs programmatically from windows form.

Or is there any other way to do this, looking forward your responses,

Sincerely,
Sathish.K

推荐答案

是的，SQL也有一些可以通过邮件发送消息的功能

这里是我建议的链接供您查看： http://www.sqlteam.com/article/sending-smtp-mail-using- a-stored-procedure [ ^ ]

（顺便说一句，我不拥有这篇文章，只是我不想重写那里的东西）



我希望这会有所帮助，



问候，

Joven

Hi,

Yes, SQL also have some features that can send message via mail
here is my suggested link for you to check out: http://www.sqlteam.com/article/sending-smtp-mail-using-a-stored-procedure[^]
(by the way i do not own this article, just i dont want to re-write the thing that is there)

I hope this helps,

Regards,
Joven

这篇关于SQL需要按照表中提到的日期发送邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！