Applies to: SQL 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.|