dbo.sysjobschedules (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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)