DBA Fundamentals: Maintenance: Agent Jobs

SQL Server started long ago, and that's why it has its own backups, emails, event logging, OS abstraction layer, and security. It invented wheels before a lot of operating systems had 'em. However, just because SQL Server has its own task scheduler - that's Agent - doesn't mean you should use it. Let's cover when you should use it, and how.

[@dominikheinz2659]

Love the strategy

[@BrentOzarUnlimited]

Thanks!

[@Kane0123]

As soon as he started with “so I went and fixed them…” I was done… you only make that mistake once.
Mine was about 4years ago.

[@BrentOzarUnlimited]

heh heh heh!

[@MiningForPies]

Anyone else cringing when he says firing jobs by name is unusual. 😳