Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Automated Administration How-to Topics (SQL Server Management Studio)

This topic defines automated administration and its components, multi-server administration, and introduces Microsoft SQL Server tools for defining automated tasks.

Automated administration is the programmed response to predictable administrative responsibilities or server events. Administrators, application writers, and analysts operating data warehouses can benefit from task automation. To automate administration:

  • Establish which administrative responsibilities or server events occur regularly and can be administered programmatically.
  • Define a set of jobs and alerts.
  • Run the SQL Server Agent service.

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 free time to perform other tasks that require creativity and lack predictable or programmable responses.

To perform general tasks with SQL Server Agent
To perform tasks that are related to SQL Server Agent Jobs
To perform tasks that are related to SQL Server Agent alerts
To perform tasks that are related to SQL Server Agent operators
To perform tasks that are related to automated administration in a multiserver environment involving master and target servers

Community Additions

© 2015 Microsoft