Blog Detail

SQL SERVER: Configure notification to send an email when JOB fails
19 Oct 2012
Tejas Shah
/Project/ImageURL/SQL Yoga Configure notification to send an email when JOB fails1_thumb[3].png
In my previous post, T SQL to display Job history, I have mentioned to get list with the job statuses. One of my developer asked me to share, How to configure Notification to send an email when Job fails. Developers problem is, he is getting empty dropdown while configuring notification as shown in below figure:

 

Here, This dropdown contains list of Operators, so we have to create operators to whom we can send a notification email. Its very simple to configure the operator, see below:

SQL Yoga Configure notification to send an email when JOB fails, create Operator #2   

Now, we have created Operator, so, lets set it up for the job as below:
SQL Yoga Configure notification to send an email when JOB fails #3  

Now, Mail will be sent to the email specified in “ErrorEmails” operator.

Note: Make sure to Configure Database email to send an email from the SQL SERVER.

Tags

SQLYoga Tejas Shah SQL Job Notification email Operator

About me

User

Tejas Shah

Microsoft Certified Professional Expert. I have 14+ years of experience in Design and Develop 100+ .Net applications using Asp.Net, C#, Asp.Net Core, VB.Net, SQL Server, MVC, AngularJS, JavaScript, Azure, HTML5 and CSS3.

Read More

Categories

Recent Post