Example: Job to Drop Text Indexes

This example drops a job for processing the text index for the table msstest1 in the data area DBTEST80.

Command

textindexjob –Ud dbtest80 msstest1

Output

c:>  Processing table msstest1
  Dropping job
EXEC msdb.dbo.sp_delete_schedule
   @schedule_name = N'TS_SCHED_dbtest80_mainline_msstest1'

go

EXEC msdb.dbo.sp_delete_jobstep
   @job_name = N'TS_dbtest80_mainline_msstest1',
   @step_id = 1

go

EXEC msdb.dbo.sp_delete_job
   @job_name = N'TS_dbtest80_mainline_msstest1'

go