The settings for SQL Server 2005 are as follows:
1. Run SQL Server Surface area configuration->surface area Configuration for features-> Select database mail-> Select Enable Database Mail Stored Procedures
2. Open SQL Management studio->management->database mail->configure SMTP Settings.
3. Open SQL Server agent->operators-> to create a new operator
4. Create a new job-> in the notification (notifications), select email and just the new operator-> choose to send email when job failure/success/completion.
5. Finally, don't forget to restart the SQL Agent
SQL Server 2008 is set to 20,051, but there is no first step.
I'm afraid it's a bit difficult for beginners to do this, but here's an example of SQL Server 2008, as illustrated in the accompanying picture.
1. Open SQL Management studio->management->database mail->configure SMTP Settings
If you are configuring for the first time, each of the following steps will appear, and if you have previously configured the appropriate options, the following step does not appear.
After configuring database email, send a test mail to test that SMTP settings are correct
2. Open SQL Server agent->operators-> to create a new operator
3. Create a new job-> in the notification (notifications), select email and just the new operator-> selection when job failure/success/completion
Because this section is not a dedicated job tutorial, so how to create a job, this article will not be attached to the map, the following set operator
Don't forget to restart the job Agent in the end
If you want to reprint, please specify this article original from csdn tjvictor column:http://blog.csdn.net/tjvictor