• Article

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.