Online Documentation for SQL Administrator for SQL Server

SQL Server Agent

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs.

SQL Server Agent uses the following components to define the tasks to be performed, when to perform the tasks, and how to report the success or failure of the tasks:

• Jobs
• Schedules
• Alerts
• Operators
• Proxies

Note: SQL Server Agent objects are available only for System Administrator role members.

The SQL Server Agent section provides information about all planned jobs that have been created on the server in the three groups: Last Run Jobs, Next Running Jobs and Failed Jobs.

Double-click the job to open it in the Job Editor.

Using the context menu of any area you can:

create a new job

edit selected job(s)

drop selected job(s)

rename job

enable job(s)

disable job(s)

start job(s)

stop job(s)

view job history

create and print the report