Full-Text Indexing Table Schedule
Use this page to set the properties of the full-text indexing schedule.
Options
- Name
Type a new name for the schedule.
- Jobs in schedule
View the jobs that use this schedule.
- Schedule type
Select the type of schedule.
- Enabled
Select or clear to enable or disable the schedule.
One-time occurrence Options
- Date
Select the date for the full-text index to run.
- Time
Select the time for the full-text index to run.
Recurring Schedule Types Options
- Occurs
Select the interval at which the schedule recurs.
- Recurs every
Select the number of days or weeks between recurrences of the schedule. This option is not available for monthly recurring schedules.
- Day
Select the day of the month the schedule occurs. Only available for monthly recurring schedules.
- of every
Select the number of months between occurrences of the schedule. Only available for monthly recurring schedules.
- Occurs once at
Set the time for a job to occur daily.
- Occurs every
Set the number of hours or minutes between occurrences.
- Starting at
Set the time at which this schedule will become effective
- Ending at
Set the time at which this schedule will no longer be effective.
- Start date
Set the date when this schedule will become effective.
- End date
Set the date when the schedule will no longer be effective.
- No end date
Specify that the schedule will remain effective indefinitely.
See Also
Other Resources
CREATE FULLTEXT INDEX (Transact-SQL)