sysjobs

Transact-SQL Reference

Transact-SQL Reference

sysjobs

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 nvarchar(30) Name 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) System identification 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 NT® 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.