Export (0) Print
Expand All

dbo.sysschedules (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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).

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.

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)

freq_subday_type

int

Units for the freq_subday_interval. Can be one of the following values:

Value

Description (unit)

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_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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft