Export (0) Print
Expand All

sysjobschedules (Transact-SQL)

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

ms188924.note(en-US,SQL.90).gifNote:
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.

Community Additions

ADD
Show:
© 2014 Microsoft