Applies To: SQL Server 2014, SQL Server 2016 Preview
Contains information about SQL Server Agent job schedules. This table is stored in the msdb database.
Applies to: SQL Server (SQL Server 2008 through current version).
ID of the SQL Server Agent job schedule.
Unique identifier of the job schedule. This value is used to identify a schedule for distributed jobs.
ID of the master server from which the job schedule came.
User-defined name for the job schedule. This name must be unique within a job.
Microsoft Windows security_identifier of the user or group that owns the job schedule.
Status of the job schedule:
0 = Not enabled.
1 = Enabled.
If the schedule is not enabled, no jobs will run on the schedule.
How frequently a job runs for this schedule.
1 = One time only
4 = Daily
8 = Weekly
16 = Monthly
32 = Monthly, relative to freq_interval
64 = Runs when the SQL Server Agent service starts
128 = Runs when the computer is idle
Days that the job is executed. Depends on the value of freq_type. The default value is 0, which indicates that freq_interval is unused.
Units for the freq_subday_interval. Can be one of the following values:
Number of freq_subday_type periods to occur between each execution of the job.
When freq_interval occurs in each month, if freq_interval is 32 (monthly relative). Can be one of the following values:
0 = freq_relative_interval is unused
1 = First
2 = Second
4 = Third
8 = Fourth
16 = Last
Number of weeks or months between the scheduled execution of a job. freq_recurrence_factor is used only if freq_type is 8, 16, or 32. If this column contains 0, freq_recurrence_factor is unused.
Date on which execution of a job can begin. The date is formatted as YYYYMMDD. NULL indicates today's date.
Date on which execution of a job can stop. The date is formatted YYYYMMDD.
Time on any day between active_start_date and active_end_date that job begins executing. Time is formatted HHMMSS, using a 24-hour clock.
Time on any day between active_start_date and active_end_date that job stops executing. Time is formatted HHMMSS, using a 24-hour clock.
Date and time that the schedule was created.
Date and time that the schedule was last modified.
Current version number of the schedule. For example, if a schedule has been modified 10 times, the version_number is 10.