Home Database Mysql Tutorial SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

Jun 07, 2016 pm 03:17 PM
database ma server sql Configuration

SQL SERVER 2008 配置 Database Mail – 用 SQL 数据库发邮件 原文来自: http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/August 23, 2008 by pinaldave 今天这篇文章我们来讨论 database

SQL SERVER 2008配置Database Mail –SQL 数据库发邮件

原文来自:http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/  August 23, 2008 by pinaldave

今天这篇文章我们来讨论database mail,也就是用SQL server发邮件的问题。关于SQL Serverdatabase mailSQLMail的区别请参考SQL SERVER – Difference Between Database Mail and SQLMail. Database Mail代替了SQLMail的功能并有很大改进,所以非常建议放弃SQL Mail将其升级到Database Mail. 在此特别对软件开发工程师Monica致谢,感谢他为本文制作了题材广泛的测试和图片。

使用SQL Server发送电子邮件邮件需要三个基本配置步骤

1) 创建配置文件和帐户  2) 配置电子邮件  3) 发送电子邮件.

步骤1)创建配置文件和帐户

您需要创建一个配置文件和配置数据库邮件向导,用以访问配置数据库邮件管理节点中的数据库邮件节点及其上下文菜单中使用的帐户。可以使用此向导来管理帐户、 配置文件和数据库邮件的全局设置,如下所示:

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

Step 2)配置邮件:

在完成账户和配置文件创建之后,我们需要配置Database Mail.为了配置它,首先需要通过 sp_configure 存储过程,启用database mail XPs 参数,如下所示:<span>sp_CONFIGURE</span><span> </span><span>'show advanced'</span><span>, </span><span>1</span>
GO
<span>RECONFIGURE</span>
<span>GO</span>
<span>sp_CONFIGURE</span><span> </span><span>'Database Mail XPs'</span><span>, </span><span>1</span>
GO
<span>RECONFIGURE</span>
<span>GO</span>

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

Step 3) 发送邮件:

如上所有配置完成之后,我们就可以发邮件了,执行存储的过程的 <span>sp_send_dbmail</span>,并提供所需的参数,如下所示:

<span>USE </span><span>msdb</span>
GO
<span>EXEC </span><span>sp_send_dbmail</span><span> </span><span>@<span>profile_name</span></span><span>=</span><span>'<span>PinalProfile</span>'</span><span>,</span>
<span>@recipients</span><span>=</span><span>'test@Example.com'</span><span>,</span>
<span>@subject</span><span>=</span><span>'Test message'</span><span>,</span>
<span>@body</span><span>=</span><span>'This is the body of the test message.</span>
Congrates Database Mail Received By you <span>Successfully</span>.'

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

输入参数的所有验证都完毕后,邮件将在Service Broker中排序等待。关于这一点,更多信息请参见SQL SERVER – Introduction to Service Broker.

Database Mail将保留发出的电子邮件的副本,我们可以通过sysmail_allitemssysmail_sentitems,sysmail_unsentitemssysmail_faileditems来查询。邮件的发送状态将保存在<span>sysmail_mailitems</span>表中,成功发送时,该表中sent_status栏目将显示为1;发送失败时,sent_status栏目将显示为2,未发送时为3 
如下所示,日志文件可以在<span>sysmail_log</span> 表中查看

<span>SELECT </span><span>*</span>
<span>FROM </span><span>sysmail_mailitems</span>
GO
<span>SELECT </span><span>*</span>
<span>FROM </span><span>sysmail_log</span>
GO

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

发送状态可以在sysmail_sentitems表中验证.

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

发送之后就可以在收件箱查阅邮件了,如下图所示是作者收到的邮件

SQL SERVER 2008配置Database Mail –用SQL 数据库发邮件

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What is the difference between HQL and SQL in Hibernate framework? What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

What is the difference between HQL and SQL in Hibernate framework?

The working principle and configuration method of GDM in Linux system The working principle and configuration method of GDM in Linux system Mar 01, 2024 pm 06:36 PM

The working principle and configuration method of GDM in Linux system

Leak reveals key specs of Intel Arrow Lake-U, -H, -HX and -S Leak reveals key specs of Intel Arrow Lake-U, -H, -HX and -S Jun 15, 2024 pm 09:49 PM

Leak reveals key specs of Intel Arrow Lake-U, -H, -HX and -S

Usage of division operation in Oracle SQL Usage of division operation in Oracle SQL Mar 10, 2024 pm 03:06 PM

Usage of division operation in Oracle SQL

Comparison and differences of SQL syntax between Oracle and DB2 Comparison and differences of SQL syntax between Oracle and DB2 Mar 11, 2024 pm 12:09 PM

Comparison and differences of SQL syntax between Oracle and DB2

Understand Linux Bashrc: functions, configuration and usage Understand Linux Bashrc: functions, configuration and usage Mar 20, 2024 pm 03:30 PM

Understand Linux Bashrc: functions, configuration and usage

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Feb 26, 2024 pm 07:48 PM

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags

How to solve the 5120 error in SQL How to solve the 5120 error in SQL Mar 06, 2024 pm 04:33 PM

How to solve the 5120 error in SQL

See all articles