dbo.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. |