How do I setup email notification when job got fail

Question

Hi, 

I have database backup job running in my production server. I am daily checking the job status for verify the job is running smoothly. 

I need to setup email notification for daily job status. Please help me to setup email notification for my production job status. 

 

Regards, 

DB@ZooM

 

Answer 1

HI again, 

I have set up database mail successfully and test mail also working fine. Now i need to set this mail when my database backup job get fail. 

Pls help me on this task...

 

Regards,

ClumsyDBA