IT:AD:SQL Server Agent

Summary

SQL Server Agent is a Microsoft Windows Service that executes jobs on a schedule, in response to a specific event, or on demand from a UI or by invoking sp_start_job.

SQL Server Agent uses SQL Server to store job information.

Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.

If the backup encounters a problem, SQL Server Agent can record the event and notify you.

Most commonly used to run IT:AD:SSIS packages.