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:...
Author: TERRY WATTS
Directing emails/alerts to the person/group who can diagnose the issue
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...
Intelligent error alerting to reduce On-call hours
Intelligent error alerting to reduce On-call hours: The purpose of this article is to get you some much needed sleep! Yes, you heard me! So try to stay awake for this! I intend to introduce you to a few tried and true strategies to improve error and issue resolution and ultimately get you and your teammates a good night’s sleep....