dbo.sysschedules (Transact-SQL)
Applies to:
SQL Server
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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru