Thanks for sharing information on setting up sql job notification. Is there a way that sends the job failure message on email.