Press "Enter" to skip to content

Tips for Managing SQL Agent Jobs

Deborah Melkin has three laws for robots, or at least SQL Agent jobs:

How do I manage this all?

I have scripts to create and modify SQL Agent jobs.

And those scripts get checked into source control.
And those scripts get added to the deploy process.
And most importantly, those scripts get tested in all environments from development through production.

Read on for more context around this.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.