IT:AD:SQL Server Agent
- See also:
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.