dbo.sysjobschedules (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains schedule information for jobs to be executed by SQL Server 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)