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