.png)
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.
NoteAfter 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).
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.
NoteThe 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.
NoteIf 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.
