14.1. Configure the SQL Server Agent Service
The SQL Server 2008 product consists of multiple Windows services. The most prominent is the SQL Server Service (MSSQLServer), which is essentially the Data Engine. The SQL Server Service provides all interaction with data and query processing. There are other services included with SQL Server 2008, however.
Another important service is the SQL Server Agent. This is the automation service. The role of the SQL Server Agent is to handle scheduling of activities and communicate information about those activities to relevant parties. To understand the SQL Server Agent, you first must understand the various artifacts that the agent controls. Then you can begin the process of configuring the service and ...
Get SQL Server® 2008 Administration: Instant Reference 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.
