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