Starting, Stopping, and Configuring SQL Server Agent
SQL Server Agent runs as a service, and it is used to schedule jobs, alerts, and other automated tasks. After you have scheduled automated tasks, you will usually want SQL Server Agent to start automatically when the system starts. This configuration ensures that the scheduled tasks are performed as expected. Using SQL Server Service Manager, you can control the related SQL Server Agent (InstanceName) service just as you do the SQL Server service. For details, see "Configuring SQL Server Services".
You use SQL Server Management Studio to configure SQL Server Agent. Chapter 16, covers the agent configuration in detail, but the basic steps are as follows:
Connect to the Database Engine on the server ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
