dbo.sysjobschedules (Transact-SQL)


Updated: August 9, 2016

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 nameData typeDescription
schedule_idintID of the schedule.
job_iduniqueidentifierID of the job.
next_run_dateintNext date on which the job is scheduled to run. The date is formatted YYYYMMDD.
next_run_timeintTime at which the job is scheduled to run. The time is formatted HHMMSS, and uses a 24-hour clock.

dbo.sysschedules (Transact-SQL)

Community Additions