Graphics and text tutorials for sending e-mail notifications when a SQL Server job runs successfully or fails _mssql2005

Source: Internet
Author: User
Tags management studio sql management studio

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.