Export (0) Print
Expand All

dbo.sysjobschedules (Transact-SQL)

Contains schedule information for jobs to be executed by SQL Server Agent. This table is stored in the msdb database.

Note Note

The sysjobschedules table refreshes every 20 minutes, which may affect the values returned by the sp_help_jobschedule stored procedure.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Community Additions

ADD
Show:
© 2014 Microsoft