dbo-sysjobs-transact-sql.md

title	dbo.sysjobs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/09/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sysjobs sysjobs_TSQL dbo.sysjobs dbo.sysjobs_TSQL
dev_langs	TSQL
helpviewer_keywords	sysjobs system table
ms.assetid	e244a6a5-54c2-47a6-8039-dd1852b0ae59
author	stevestein
ms.author	sstein

dbo.sysjobs (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Stores the information for each scheduled job to be executed by [!INCLUDEssNoVersion] 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.