SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task,i.e: backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.
Create a scheduled Job
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0