Thursday, July 27, 2017

Steps to improving the MS SQL Agent


1. Allow for better error handling in SQL agent jobs

For example Error 12 may not mean a complete failure. don't make me have to create a wrapper to take of this.. Allow me to set success and error flags (and what to do)

2. Allow for If X = THIS THEN DO THAT ELSE SKIP

3. Allow us to disable steps. sometimes we just want to skip a step without having to remove the step completely

4. Allow the Error log to be included /attached in the e-mail notifications

If you find this article useful please leave me a comment.

No comments :

Post a comment