Chapter 5: Automating SQL Server

Overview

Much of the work that a DBA does is repetitive: backing up databases, rebuilding indexes, and checking for file sizes and disk-space availability. Responding to events such as the transaction log being full or being out of disk space may also be part of daily life for some DBAs. The problem grows rapidly with the number of servers you must administer. Automating this work is more than a convenience; it is a requirement for enterprise systems.

SQL Server Agent comes to the rescue, allowing you to automate routinely scheduled tasks, respond to predefined events, and notify you of status.