Implement Jobs

APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure SQL Data Warehouse noParallel Data Warehouse

Important

On Azure SQL Database Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details.

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.

Description Topic
Contains information about creating jobs and assigning ownership. Create Jobs
Contains information about organizing jobs into categories. Organize Jobs
Contains information about the different kinds of job steps you can create and how to manage them. Manage Job Steps
Contains information about how to define when jobs start running and how often they should run. Create and Attach Schedules to Jobs
Contains information about manually running jobs (without a schedule). Run Jobs
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. Specify Job Responses
Contains information about how to view existing jobs, their history once executes, and how to modify them. View or Modify Jobs
Contains information about how to delete jobs. Delete Jobs

See Also

Implement SQL Server Agent Security