sysjobschedules (Transact-SQL)

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