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

• 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.