sysschedules#
Contains information about job schedules.
Column name |
Data type |
Description |
|---|---|---|
schedule_id |
int |
ID of the job schedule. |
schedule_uid |
uniqueidentifier |
Unique identifier of the job schedule. |
originating_server_id |
int |
ID of the master server from which the job schedule came. |
name |
sysname |
User-defined name for the job schedule. This name must be unique within a job. |
owner_sid |
varbinary(85) |
Security identifier of the user or group that owns the job schedule. |
enabled |
int |
Status of the job schedule: 0 = Not enabled, 1 = Enabled. If the schedule is not enabled, no jobs will run on the schedule. |
freq_type |
int |
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 scheduler starts, 128 = Runs when the computer is idle |
freq_interval |
int |
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. See the table below for the possible values and their effects. |
freq_subday_type |
int |
Units for the freq_subday_interval. The following are the possible values and their descriptions. 1 : At the specified time, 2 : Seconds, 4 : Minutes, 8 : Hours |
freq_subday_interval |
int |
Number of freq_subday_type periods to occur between each execution of the job. |
freq_relative_interval |
int |
When freq_interval occurs in each month, if freq_type 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 |
freq_recurrence_factor |
int |
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. |
active_start_date |
int |
Date on which execution of a job can begin. The date is formatted as YYYYMMDD. NULL indicates today’s date. |
active_end_date |
int |
Date on which execution of a job can stop. The date is formatted YYYYMMDD. |
active_start_time |
int |
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. |
active_end_time |
int |
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_created |
datetime |
Date and time that the schedule was created. |
date_modified |
datetime |
Date and time that the schedule was last modified. |
version_number |
int |
Current version number of the schedule. For example, if a schedule has been modified 10 times, the version_number is 10. |
Value of freq_type |
Effect on freq_interval |
|---|---|
1 (once) |
freq_interval is unused (0) |
4 (daily) |
Every freq_interval days |
8 (weekly) |
freq_interval is one or more of the following: 1 = Sunday, 2 = Monday, 4 = Tuesday, 8 = Wednesday, 16 = Thursday, 32 = Friday, 64 = Saturday |
16 (monthly) |
On the freq_interval day of the month |
32 (monthly, relative) |
freq_interval is one of the following: 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday, 8 = Day, 9 = Weekday, 10 = Weekend day |
64 (starts when scheduler starts) |
freq_interval is unused (0) |
128 (runs when computer is idle) |
freq_interval is unused (0) |