Example: Recurring Text Index Population Job Schedule

This example creates a text index job, job step and schedule that populates the text index every day at 11:00 PM starting 2007/01/01, for table msstest1 in the data area DBTEST80.

FREQ_TYPE=4
FREQ_INTERVAL=1
FREQ_SUBDAY_TYPE=1
ACTIVE_START_DATE=20070101
ACTIVE_START_TIME=230000

textindexjob –Uc dbtest80 msstest1

  Processing table msstest1
  Creating job
EXEC msdb.dbo.sp_add_job
   @job_name = N'TS_dbtest80_mainline_msstest1'

go

EXEC msdb.dbo.sp_add_jobstep
   @job_name = N'TS_dbtest80_mainline_msstest1',
   @step_name = N'TS_STEP_dbtest80_mainline_msstest1',
   @step_id = 1,
   @subsystem = N'TSQL',
   @command = N'exec alter fulltext index on mainline.
      msstest1 start incremental population',
   @database_name = N'dbtest80'

go

EXEC msdb.dbo.sp_add_jobschedule
   @job_name = N'TS_dbtest80_mainline_msstest1',
   @name = N'TS_SCHED_dbtest80_mainline_msstest1',
   @freq_type = 4,
   @freq_interval = 1,
   @freq_subday_type = 1,
   @freq_subday_interval = 0,
   @freq_relative_interval = 0,
   @freq_recurrence_factor = 0,
   @active_start_date = 20070101,
   @active_end_date = 230000,
   @active_start_time = 000000,
   @active_end_time = 235959

go