SQL Server DBA Tutorial 133-How to Setup the Email Notificaion For Job Failure on SQL Server

This video explains step by step process of setting up the email notification if SQL Server Agent Job fails. It explains using SQL Server agent notification where you configure the Job system alert to send an email in case job fails or completes. It also shows step by step process of using sp_send_email notification store procedure to use in SQL Server agent job and notify operator in case job fails.

Blog post link for the video

Visit our website to check out SQL Server DBA Tutorial Step by Step

[RIDDLEMASTER]

Good, clear and to the point! Really like your videos!

[JoeVago]

Extremely well done tutorial video - Thank you!

[developershandbook]

Hi, Is there a way to include more detailed description of the failure in the email notification. I am using it to notify SSIS job failure. In that case, is it possible to send email with information about the failed SSIS component?

[hiteshborkar]

Hi Techbrothers, thanks for this video.

I have a question, can we customize the message in the job failure notification message as per our need? because right now I am getting job failure but it is the default one as follows:


JOB RUN: 'Disk alert' was run on 1/27/2017 at 10:35:31 AM
DURATION: 0 hours, 0 minutes, 3 seconds
STATUS: Succeeded
MESSAGES: The job succeeded. The Job was invoked by User sa. The last step to run was step 1 (Disk alert).

I am talking about the last line. thank you in advance.

[Shuip]

Can you tell me if I can insert more than one "E-mail Name" on the "Notification Options" on one Operator? (min 3:13)
And can I use more than one Database mail Account/Profile to send notifications into diferent Jobs ? (min 2:23)

[bimithmaramveettill]

sir i have configured as per your video after the job execution manually we execute the script
it will send the mail with attachment but if try under a job create a notification email
it will not sending any emails we are getting kind of below erro
Failed to open attachment file
Executing API 'CreateFile' failed with errror no 32
kindly suggest me

[manoharchowdarycherukuri]

My requirement is without adding as a second step, i need to send a email notification when job fails by using operator. Pls Provide the Script for that. Help me out of this.

[luffyy]

Would be great if you give video link of operator on top right corner or description