SQL Server Agent

SQL Server Agent is a Microsoft Windows service that allows you to automate some administrative tasks. SQL Server Agent runs jobs, monitors SQL Server, and processes alerts. The SQL Server Agent service must be running before local or multiserver administrative jobs can run automatically.

In This Section

Topic Description

Configuring SQL Server Agent

Contains information about how you can configure SQL Server Agent during installation of SQL Server. It also describes what permissions an account must have to run and administer SQL Server Agent jobs.

Starting, Stopping, and Pausing SQL Server Agent Service

Contains information about getting started with SQL Server Agent.

Selecting an Account for the SQL Server Agent Service

Contains information about the SQL Server Agent startup account and the network permissions it needs.

Connecting to SQL Server by Using SQL Server Agent Service

Contains information about how to connect to an instance of SQL Server with SQL Server Agent.

Specifying a SQL Server Alias

Contains information about when and how you can specify a server connection alias for the SQL Server Agent service.

Using the SQL Server Agent Error Log

Contains information about how to use the SQL Server Agent error log.

Managing Services

Contains information about how to restart the SQL Server and the SQL Server Agent services.

Using Performance Objects

Contains information about the performance objects you can use to view SQL Server Agent objects, jobs, job steps, alerts, and general statistics.