SQL Maintenance Jobs

# SQL Maintenance Jobs One common question I get is what kind of maintenance do you perform on the databases. My maintenance routines are created using Ola Hallengren scripts. - 

@[SQL Server Backup, Integrity Check, Index and Statistics Maintenance (hallengren.com)](https://ola.hallengren.com/)

As you can see from my screen shot it creates all the jobs. I have also added a job to disable Operators. This will stop the email spam when a SQL server alerts repeatedly. After a certain amount of time it will enable the operator account again. I also prefix my job names with DBA Care to keep the jobs separate from the business jobs

Post a Comment

0 Comments