Tools for Automating Administration
SQL Server includes the following tools to help you automate administration.
SQL Server Management Studio
You can use SQL Server Management Studio to automate administration by creating jobs, alerts, operators, and proxies in the SQL Server Agent node of Object Explorer. For more information, see Creating DMX Queries in SQL Server Management Studio.
Maintenance Plan Wizard
Maintenance Plan Wizard is a utility that can help you create jobs, alerts, and operators to automate administration of an instance of SQL Server. For more information, see Maintenance Plan Wizard.