Skip to content

Latest commit

 

History

History
46 lines (38 loc) · 3.06 KB

File metadata and controls

46 lines (38 loc) · 3.06 KB
title Create Jobs | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.suite
ms.technology
dbe-cross-instance
ms.tgt_pltfrm
ms.topic conceptual
helpviewer_keywords
jobs [SQL Server Agent], creating
SQL Server Agent jobs, creating
ms.assetid 465fb7fc-7622-4252-a178-ea51691c935b
caps.latest.revision 34
author stevestein
ms.author sstein
manager craigg

Create Jobs

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 prompt applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks. Jobs can run repetitive or schedulable tasks, and they can automatically notify users of job status by generating alerts, thereby greatly simplifying [!INCLUDEssNoVersion] administration.

To create a job, a user must be a member of one of the [!INCLUDEssNoVersion] Agent fixed database roles or the sysadmin fixed server role. A job can be edited only by its owner or members of the sysadmin role. Members of the sysadmin role can assign job ownership to other users, and they can run any job, regardless of the job owner. For more information about the [!INCLUDEssNoVersion] Agent fixed database roles, see SQL Server Agent Fixed Database Roles.

Jobs can be written to run on the local instance of [!INCLUDEssNoVersion] or on multiple instances across an enterprise. To run jobs on multiple servers, you must set up at least one master server and one or more target servers. For more information about master and target servers, see Automated Administration Across an Enterprise

[!INCLUDEssNoVersion] Agent records job and job step information in the job history.

Related Tasks

Description Topic
Describes how to create a [!INCLUDEssNoVersion] Agent job. Create a Job
Describes how to reassign ownership of [!INCLUDEssNoVersion] Agent jobs to another user. Give Others Ownership of a Job
Describes how to set up the [!INCLUDEssNoVersion] Agent job history log. Set Up the Job History Log

See Also

Manage Job Steps
Automated Administration Across an Enterprise
Create and Attach Schedules to Jobs
Run Jobs
View or Modify Jobs