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

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 the 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

Concepts

Surface Area Configuration for Services and Connections
Surface Area Configuration for Features

Help and Information

Getting SQL Server 2005 Assistance