Jobs Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Jobs Editor lets you modify the definition of a SQL Agent job.

To edit a job

  1. Open an editor on the job. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

This tab/panels lets you specify an Enabled/disabled status and select a Category, as well as specify notify and delete levels for the job. For details on these settings, see Jobs (SQL Server) - Properties.

Steps

This tab/panels lets you work with the steps for a job, including subsystem specifics, success/failure/ retry details, and logging and file specifications. For details on these settings, see Jobs (SQL Server) - Steps.

Schedules

This tab/panels lets you create new schedules for this job, add schedules that were defined in other job definitions, delete schedules currently associated with the current job definition, and display all jobs using a selected schedule. For detailed instructions, see Jobs (SQL Server) - Schedules.

Alerts

On opening, this tab provides a list of all alerts that specify this job as the target job to be executed in response to those alerts. You can create new alert definitions and edit existing definitions from the list. When you execute the job that creates or edits this job, DDL to create all alerts on this tab is submitted. For detailed instructions, see Jobs (SQL Server) - Alerts.

Target

Lets you specify the server or servers where the job executes. For details, see Jobs (SQL Server) - Target.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.