dbo.sysschedules (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

Contains information about SQL Server Agent job schedules. This table is stored in the msdb database.

Column name Data type Description
schedule_id int ID of the SQL Server Agent job schedule.
schedule_uid uniqueidentifier Unique identifier of the job schedule. This value is used to identify a schedule for distributed jobs.
originating_server_id int ID of the master server from which the job schedule came.
name sysname (nvarchar(128)) User-defined name for the job schedule. This name must be unique within a job.
owner_sid varbinary(85) Microsoft Windows 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 SQL Server Agent service 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 SQL Server Agent service starts) freq_interval is unused (0)
128 (runs when computer is idle) freq_interval is unused (0)

See also

dbo.sysjobschedules (Transact-SQL)