Surface Area Configuration for Services and Connections (Service) - SQL Server Agent

SQL Server Setup

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.

See Also