Skip to content

Latest commit

 

History

History
43 lines (36 loc) · 3.21 KB

implement-jobs.md

File metadata and controls

43 lines (36 loc) · 3.21 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Implement Jobs
Implement Jobs
markingmyname
maghan
01/19/2017
sql
ssms
how-to
jobs [SQL Server Agent]
SQL Server Agent jobs
SQL Server Agent jobs, about jobs
jobs [SQL Server Agent], about jobs
= azuresqldb-mi-current || >= sql-server-2016

Implement Jobs

[!INCLUDE SQL Server SQL MI]

Important

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

You can use [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Agent. A job can perform a wide range of activities, including running [!INCLUDEtsql] 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 [!INCLUDEssNoVersion] 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. 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 [!INCLUDEssNoVersion] Agent to respond to jobs. For example, you can configure [!INCLUDEssNoVersion] 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