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).
Further defines the frequency_interval when frequency_type is set to 32 (monthly relative).
frequency_relative_interval is int, with no default, and can be one of the following values:
frequency_relative_interval indicates the occurrence of the interval. For example, if frequency_relative_interval is set to 2, frequency_type is set to 32, and frequency_interval is set to 3, the scheduled job would occur on the second Tuesday of each month.
Number of weeks or months between the scheduled execution of the job. frequency_recurrence_factor is used only if frequency_type is set to 8, 16, or 32. frequency_recurrence_factor is int, with a default of 0.
[ @active_start_date= ] active_start_date
Date on which job execution can begin. active_start_date is int, with no default. The date is formatted as YYYYMMDD. If active_start_date is set, the date must be greater than or equal to 19900101.
After the schedule is created, review the start date and confirm that it is the correct date. For more information, see the section "Scheduling Start Date" in Create and Attach Schedules to Jobs.
[ @active_end_date= ] active_end_date
Date on which job execution can stop. active_end_date is int, with no default. The date is formatted as YYYYMMDD.
[ @active_start_time= ] active_start_time
Time on any day between active_start_date and active_end_date to begin job execution. active_start_time is int, with no default. The time is formatted as HHMMSS on a 24-hour clock.
Time on any day between active_start_date and active_end_date to end job execution. active_end_time is int, with no default. The time is formatted as HHMMSS on a 24-hour clock.
Schedule identification number assigned to the schedule if it is created successfully. schedule_id is an output variable of type int, with no default.
[ @schedule_uid= ] schedule_uidOUTPUT
A unique identifier for the schedule. schedule_uid is a variable of type uniqueidentifier.