New Full-Text Indexing Table Schedule
Use this dialog box to schedule a job to perform a full-text population on the base table.
Name
Specify a name for this schedule.Jobs in Schedule
View the associated job for an existing schedule.Schedule type
Select the type of schedule.Start automatically when SQL Server Agent starts
Start the job when the SQL Server Agent service is started.
Start whenever the CPUs become idle
Start the job during periods of low activity.
Recurring
Schedule the job to run more than once. To specify the recurrence interval, complete the Frequency, Daily frequency, and Duration panels on the dialog box.
One time
Select to run the job only once. To set a one-time schedule, complete the One-time occurrence panel on the dialog box.
Enabled
Select to enable the schedule (the default), or clear to disable the schedule.Note
After you create a schedule, you can enable or disable it from the Schedules page of the Full-Text Index Properties dialog box. For information about accessing that page, see How to: View or Change the Properties of a Full-Text Index (SQL Server Management Studio).
One-Time Occurrence
This panel is enabled only if Schedule type is set to One time.
Date
Specify the date to run the job.Time
Specify the time of day to run the job.
Frequency
This panel is enabled only if Schedule type is set to Recurring.
Occurs
Select one of the following time intervals:Daily
Select to run this job once a week.
Weekly
Select to run this job once a week.
Monthly
Select to run this job once a month.
Note
The value of Occurs determines what other options are displayed in the Frequency panel.
Recurs every
If Occurs is set to Daily, specify the number of days that will elapse from one job run to the next. For example, if you want to run the job every third day, select 3.If Occurs is set to Weekly, specify the number of weeks that will elapse after running the job until running them the next time. For example, to run the schedule every other week, select 2.
Also specify the names of the days on which to run the job.
Day … of every
If Occurs is set to Monthly, you can select this option to specify the occurrence in terms of:The day of the month (from 1 to 31) on which to run the job.
The number of months that will elapse from one job run to the next. For example, to run the job once a month, select 1.
Note
If you specify a day number greater than the number of days in a given month, the job would not run that month.
The … of every
Alternatively, if Occurs is set to Monthly, you can select this option to specify the occurrence in terms of:The position in the month (such as first or last) of the day that you select in the next field.
The day on which to run the schedule, one of:
The name of a particular day (such as Monday).
Whatever day corresponds to the selected position you select (day).
Anytime during the week (weekday).
Anytime during the weekend (weekend day).
The number of months to wait before rerunning the job.
For example, to run the job on the last weekday of each month, select last, weekday, and 1.
Daily Frequency
This panel is enabled only if Schedule type is set to Recurring.
Occurs once at
You can select this option to specify an exact time of day to run the job.Occurs every
Alternatively, you can select this option to specify the frequency in terms of the number of hours (1-24), minutes (1-60), or seconds (1-60) along with the exact starting and ending times (Starting at and Ending at). The default times cover the entire day, starting at the time when you began creating this schedule.
Duration
This panel is enabled only if Schedule type is set to Recurring.
Start date
Specify the date on which to run the job for the first time.End date
Specify the last date on which to run the job.No end date
Maintain the schedule indefinitely.
Summary
This panel summarizes the schedule.
- Description
Describes the current schedule so you can verify whether it is correct. If you change the schedule, this description will change accordingly.