Example: Daily text index population job

The steps in this example create a text index job, jobstep and schedule for the table TEST1 in the data area DBTEST80. This job will populate the text index everyday at 11:00 PM starting 2007/01/01.

  1. Open the %LARUNDIR%\DATAAREA\db.cfg file and add the following parameters: 
    CHANGE_TRACKING=MANUAL
FREQ_TYPE=4
FREQ_INTERVAL=1
FREQ_SUBDAY_TYPE=1
ACTIVE_START_DATE=20070101
ACTIVE_START_TIME=230000
  2. At a Landmark command prompt, type

    textindexjob –Uc dbtest80 test1

    The results are as follows:

    c:>  Processing table test1
  Creating job
EXEC msdb.dbo.sp_add_job
   @job_name = N'TS_dbtest80_mainline_TEST1'

go

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

go

EXEC msdb.dbo.sp_add_jobschedule
   @job_name = N'TS_dbtest80_mainline_TEST1',
   @name = N'TS_SCHED_dbtest80_mainline_TEST1',
   @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