Suppose you’ve been working on cleaning up SQL Agent jobs and their email operators and find that you have more than one operator with the same email address. How would you tidy this up to ease administration? Let’s do a little setup to demonstrate …
How would you go about finding jobs that have failed and why would you want to look for these? You might want to do this to ensure that you are being notified appropriately of job failures. For instance, after reviewing failed jobs, you may realize …
In the last post we found jobs that had no email notification. Once you find them, how do you fix this problem? I’m going to assume that database mail is already enabled and configured on the SQL Server instance. 1. Create an operator, assuming one …
When you take over a new SQL Server instance one of the things you might consider doing early on is finding SQL Agent jobs that have no email notification set up. These will be jobs that could fail and they will never alert anyone. I am of the …