Export (0) Print
Expand All

New Full-Text Indexing Table Schedule

SQL Server 2008

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.

NoteNote

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).

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.

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.

NoteNote

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.

Dayof 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.

NoteNote

If you specify a day number greater than the number of days in a given month, the job would not run that month.

Theof 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.

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.

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft