dbo.sysjobs (Transact-SQL)
Applies to: SQL Server
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. |