Create an Email notification template: Now, putting it all together; we want to send out informative consistent email alerts to reduce the amount time needed to correct on-call issues. Using the information you have previously gathered for each job we will create an email that matches the Sample Email Template defined below. Sample Email Template: From: [DB Mail Account] To:...

Directing emails/alerts to the person/group who can diagnose the issue We need to determine which team should be contacted first if a given job (or job step in some cases) fails! A lot of times when there is an error in the middle of the night, the chances are that the DBA did not author the failing process and therefore...