Online Documentation for SQL Administrator for SQL Server

Setting job properties

Use the Job tab of the Job Editor to configure/view job properties.

Name

Enter a name for the new job, or modify the name of the job being edited. Enable/disable the job using the Enabled option.

Owner

Use the drop-down list to select the job owner.

Note: To create a job, a user must be a member of one of the SQL Server 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.

Category

Use the drop-down list to select the job category.

Job categories help you organize your jobs for easy filtering and grouping. For example, you can organize all your database backup jobs in the Database Maintenance category. You can add a new job category by pressing the Add button.

Description

In this memo field you can supply an optional description for the job.

The lower area displays the following job events and properties:

Source server

Created at

Last modified at

Last run at

Last run outcome

Next run at