Skip to content

Latest commit

 

History

History
38 lines (32 loc) · 1.41 KB

dbo-sysjobschedules-transact-sql.md

File metadata and controls

38 lines (32 loc) · 1.41 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
dbo.sysjobschedules (Transact-SQL)
dbo.sysjobschedules (Transact-SQL)
VanMSFT
vanto
08/09/2016
sql
system-objects
reference
sysjobschedules
dbo.sysjobschedules
dbo.sysjobschedules_TSQL
sysjobschedules_TSQL
sysjobschedules system table
TSQL

dbo.sysjobschedules (Transact-SQL)

[!INCLUDE SQL Server]

Contains schedule information for jobs to be executed by [!INCLUDEssNoVersion] Agent. This table is stored in the msdb database.

Note

The sysjobschedules table refreshes every 20 minutes, which may affect the values returned by the sp_help_jobschedule stored procedure.

Column name Data type Description
schedule_id int ID of the schedule.
job_id uniqueidentifier ID of the job.
next_run_date int Next date on which the job is scheduled to run. The date is formatted YYYYMMDD.
next_run_time int Time at which the job is scheduled to run. The time is formatted HHMMSS, and uses a 24-hour clock.

See Also

dbo.sysschedules (Transact-SQL)