How to Setup Email notification for JOB Failure in SQL server || Ms SQL

In this video i have explained the step by step process of setting up the email notification if any SQL Server Agent Job fails.

There are two ways to send a notofication.
1. SQL server agent notification

How to setup Database mail in SQL server
Click below to Watch

[kennethskinner]

3 years later and it's still helpful!

[wvgtdkw]

Not able to configure with gmail account...is there any additional settings needed to setup

[maheshwara.r.]

Hi Balu..

I have a scenario.. I have an SQL Query with 2 tables if the Query Results more then ZERO records I need to trigger email Notifications to the Configured Email IDs using Stored Procedure, or Trigger or any other DB object by just calling it. It is MS Server Env..

[Jerry-zsbp]

Hi bro could ypu please explain me hot to enable server agent in sql it is missing in my case

[nreshma]

Hi, can you do video on how to setup job failures notifications on multiple servers, basically like a health check on multiple servers.

[abhishektambewagh]

How to create alerts for multiple jobs

[TKJ]

Sometimes the package fail with 'Unexpected termination' so can we get mail alert on it?

[kandagatlashivasai]

Could you make videos on triggers, indexes

[cinap]

Bro how to create error log alerts to mail please help

[coxanagi]

what if I want to send a notification to multiple email accontus?? How do I setup the Operators profile?

[sridharm]

how to alert if the job is taking more than 5 mins

[sridharm]

How to Alert by email in the below following condition
1: If enable manually or automatically
2:IF Disabled manually or automatically
3: If Jobs takes more than 5 mins.