Maintenance Jobs any SQL DBA should have in production

I recently stumbled upon an article by Tara Kizer that lists her commonly used db tasks. I think this article is pure gold and would like to share it with you. I already implemented a few of these jobs on my production servers and I am beginning to see positive results. Tara is suggesting to put maintenance jobs into a database dedicated just for that, maintenance and then schedule these stored procedures as jobs. Read Link


Enjoy!

Comments

Popular posts from this blog

VirtualBox options to start VM in Normal, Detached and Headless Modes

Digsby is bringing out a Linux and Mac client very soon

Executing Python and Python3 scripts in Oozie workflows