This topic defines automated administration and its components, multiserver administration, and introduces Microsoft® SQL Server™ tools you can use to define tasks for automation.
Automated administration is the programmed response to a predictable administrative responsibility or server event. Administrators, application writers, and analysts operating data warehouses can benefit from task automation. To automate administration:
The job of an administrator entails various administrative duties that do not change from day to day and can be tedious chores. By automating recurring administrative tasks and responses to server events, you can free time to perform administrative tasks that require creativity and lack predictable or programmable responses.