Configuring SQL Server e-mail and JOB notification notification capabilities

The process of configuring mail for SQL Server 2008 is not written, and there are too many cases on the web.

Http://www.cnblogs.com/woodytu/p/5154526.html this case is good.

The main write down after the configuration of error handling:

Database Mail failure Microsoft Official website:

1. SQL Server 2008 blocked the component ' Database Mail XPS '

Run the following code in the msdb database:

EXEC sys.sp_configure N ' Show advanced options ', 1RECONFIGURE with  OVERRIDE;; EXEC sys.sp_configure ' Database Mail XPs ', 1; RECONFIGURE with   OVERRIDE;

2. Clear the messages in the queue:

DECLARE @GETDATE datetime SET @GETDATE = GETDATE () EXECUTE msdb.dbo.sysmail_delete_mailitems_sp @sent_before = @GETDATE; GO

　　

Configure the notification notification feature for the JOB:

1. Add a operator operator:

Use [email protected] as the receiving email address, SMTP is the account that sends the mail, here the notification Is the account that receives the mail. This address is preferably a public email address that maps or contains all the messages for the entire team, ensuring that each member of the team can receive email notifications. Change the SQL Server Agent properties selected in Alert System before configuring Biwork profile It contains the SMTP send mail Service [email protected] Account

You can generally not restart the SQL Server Agent, but you can restart it if the test does not take effect later .

Once the above is configured, it can be configured in the job under construction.

After the configuration is complete, wait patiently for a minute to receive a notification e-mail!

Configuring SQL Server e-mail and JOB notification notification capabilities