







SQL Server Setup Help | |
Surface Area Configuration for Services and Connections (Service) - SQL Server Agent | |
![]() |
![]() ![]() |
Configuring a SQL Server Installation > SQL Server Surface Area Configuration > Surface Area Configuration for Services and Connections > |
Microsoft SQL Server Agent Windows services are installed with instances of the Database Engine. By default, this service is disabled and stopped. If you want to use automated administration, you must enable this service. Use this dialog to change service settings. For more information about configuring the SQL Server Agent service account, see Selecting an Account for SQL Server Agent Service in Microsoft SQL Server 2005 Books Online.
Options
- Service name
-
The name of the service.
- Display name
-
The name that appears in the Name column in the Windows Services panel.
- Description
-
The service description, which also appears in the Description column of the Microsoft Windows services panel.
- Startup type
-
Use to configure how the service starts.
Automatic specifies that the service starts when the system starts.
Manual specifies that a user or dependent service can start the service, and that the service does not start when the system starts.
Disabled prevents the service from being started by the system, a user, or any dependent service.
- Service status
-
Shows the status of the service.
- Start button
-
Starts the service.
- Stop button
-
Stops the service.
- Pause button
-
Pauses the service.
- Resume button
-
Resumes the paused service.