sysjobs (Transact-SQL)

Stores the information for each scheduled job to be executed by SQL Server Agent. This table is stored in the msdb database.

Column name

Data type

Description

job_id

uniqueidentifier

Unique ID of the job.

originating_server_id

int

ID of the server from which the job came.

name

sysname

Name of the job.

enabled

tinyint

Indicates whether the job is enabled to be executed.

description

nvarchar(512)

Description for the job.

start_step_id

int

ID of the step in the job where execution should begin.

category_id

int

ID of the job category.

owner_sid

varbinary(85)

Security identifier number (SID) of the job owner.

notify_level_ eventlog

int

Bitmask indicating under what circumstances a notification event should be logged to the Microsoft Windows application log:

0 = Never

1 = When the job succeeds

2 = When the job fails

3 = Whenever the job completes (regardless of the job outcome)

notify_level_email

int

Bitmask indicating under what circumstances a notification e-mail should be sent when a job completes:

0 = Never

1 = When the job succeeds

2 = When the job fails

3 = Whenever the job completes (regardless of the job outcome)

notify_level_netsend

int

Bitmask indicating under what circumstances a network message should be sent when a job completes:

0 = Never

1 = When the job succeeds

2 = When the job fails

3 = Whenever the job completes (regardless of the job outcome)

notify_level_page

int

Bitmask indicating under what circumstances a page should be sent when a job completes:

0 = Never

1 = When the job succeeds

2 = When the job fails

3 = Whenever the job completes (regardless of the job outcome)

notify_email_ operator_id

int

E-mail name of the operator to notify.

notify_netsend_ operator_id

int

ID of the computer or user used when sending network messages.

notify_page_ operator_id

int

ID of the computer or user used when sending a page.

delete_level

int

Bitmask indicating under what circumstances the job should be deleted when a job completes:

0 = Never

1 = When the job succeeds

2 = When the job fails

3 = Whenever the job completes (regardless of the job outcome)

date_created

datetime

Date the job was created.

date_modified

datetime

Date the job was last modified.

version_number

int

Version of the job.