You can use SQL Server Agent jobs to automate routine administrative tasks and run them on a recurring basis, making administration more efficient.
A job is a specified series of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command-line applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks. Jobs can run repetitive tasks or those that can be scheduled, and they can automatically notify users of job status by generating alerts, thereby greatly simplifying SQL Server administration.
You can run a job manually, or you can configure it to run according to a schedule or in response to alerts.
Related Tasks
Description
Topic
Contains information about creating jobs and assigning ownership.
Contains information about how you can configure SQL Server Agent to respond to jobs. For example, you can configure SQL Server Agent to notify administrators when jobs are finished.
Administrați o infrastructură de bază de date SQL Server pentru baze de date în cloud, locale și relaționale hibride utilizând ofertele de baze de date relaționale Microsoft PaaS.