Automating Database Administration with SQL Server Agent

By Mike Chapple, About.com Guide

SQL Server Agent allows you to automate a variety of administrative tasks. In this tutorial, we walk through the process of using SQL Server Agent to create and schedule a job that automates database administration.

Open up Microsoft SQL Server Configuration Manager and locate the SQL Server Agent service. If the status of that service is "RUNNING", you do not need to do anything. Otherwise, right-click on the SQL Server Agent service and select Start from the pop-up menu. You'll see the Starting Service window shown above.

Previous

• Start the SQL Server Agent Service
• Open SQL Server Management Studio and Expand the SQL Server Agent Folder
• Create a New SQL Server Agent Job
• Enter the SQL Server Agent Job Steps Screen
• Add SQL Server Agent Job Steps
• Schedule the SQL Server Agent Job

Next