如何从sql自动发送邮件 [英] How to send a mail automatically from sql

问题描述

大家好，





如果用昨天的日期更新表，如何每天从sql自动发送邮件。< br $>




请给我建议。





提前致谢

Sucharitha

解决方案

访问这里...





http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/ [ ^ ]



或



http://www.aspforums.net/Threads/142526/sending-automatic-mail-usign -SQL- server-job-scheduler / [ ^ ]

如何从sql发送电子邮件

创建发送电子邮件的存储过程



在SQL Server存储过程中发送电子邮件 - 教程 [ ^ ]



使用SQL Server作业调用此存储过程。它应该安排在每天运行。



安排工作 [ ^ ]



如何安排sql查询的作业每天运行？ [ ^ ]



如果你想要在数据库发生变化之后做一些事情，那就是触发它的好处



触发器 - Sql Server [ ^ ]



就是这样。



问候.. :)

Hi All,


How to send a mail automatically from sql every day when the table is updated with yesterday's date.


Please advice me.


Thanks in advance
Sucharitha

解决方案

visit here...


http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/[^]

or

http://www.aspforums.net/Threads/142526/sending-automatic-mail-usign-SQL-server-job-scheduler/[^]

how to send email from sql

Create Stored Procedure that sends email

Send Email in SQL Server Stored Procedure - Tutorial[^]

Call this Stored Procedure with SQL Server Job. It should be scheduled to run every day.

Schedule a Job[^]

how to schedule a job for sql query to run daily?[^]

If you want to do something after changes in database that its good to go with Triggers

Triggers -- Sql Server[^]

That's it.

Regards..:)

这篇关于如何从sql自动发送邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！