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 ensures that the scheduled tasks are performed as expected. Using SQL Server Configuration Manager, you can control the related service (SQLServerAgent or SQLAgent$instancename) just as you do the SQL Server service. For details, see the section titled "Configuring SQL Server Services" in Chapter 3.
You use SQL Server Management Studio to configure SQL Server Agent. Chapter 15, covers the agent configuration in detail, but the basic steps are as follows:
Connect ...
Get Microsoft® SQL Server™ 2005 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.
