USE [PengellysWebsite] GO CREATE FULLTEXT INDEX ON [dbo].[Link] KEY INDEX [PK_Link] ON ([fulltextCatalog]) WITH (CHANGE_TRACKING AUTO) GO USE [PengellysWebsite] GO ALTER FULLTEXT INDEX ON [dbo].[Link] ADD ([Title]) GO USE [PengellysWebsite] GO ALTER FULLTEXT INDEX ON [dbo].[Link] ADD ([LinkUrl]) GO USE [PengellysWebsite] GO ALTER FULLTEXT INDEX ON [dbo].[Link] ENABLE GO USE [msdb] GO DECLARE @jobId BINARY(16) EXEC msdb.dbo.sp_add_job @job_name=N'Start Optimize Catalog Population on PengellysWebsite.fulltextCatalog', @enabled=1, @start_step_id=1, @description=N'Scheduled full-text optimize catalog population for full-text catalog fulltextCatalog in database PengellysWebsite. This job was created by the Full-Text Catalog Scheduling dialog or Full-Text Indexing Wizard.', @category_name=N'Full-Text', @job_id = @jobId OUTPUT select @jobId GO EXEC msdb.dbo.sp_add_jobserver @job_name=N'Start Optimize Catalog Population on PengellysWebsite.fulltextCatalog', @server_name = N'sql2' GO USE [msdb] GO DECLARE @schedule_id int EXEC msdb.dbo.sp_add_jobschedule @job_name=N'Start Optimize Catalog Population on PengellysWebsite.fulltextCatalog', @name=N'Indexing', @enabled=1, @freq_type=128, @freq_interval=1, @freq_subday_type=0, @freq_subday_interval=0, @freq_relative_interval=0, @freq_recurrence_factor=1, @active_start_date=20140313, @active_end_date=99991231, @active_start_time=0, @active_end_time=235959, @schedule_id = @schedule_id OUTPUT select @schedule_id GO USE [msdb] GO EXEC msdb.dbo.sp_add_jobstep @job_name=N'Start Optimize Catalog Population on PengellysWebsite.fulltextCatalog', @step_name=N'Full-Text Indexing', @step_id=1, @cmdexec_success_code=0, @on_success_action=1, @on_success_step_id=-1, @on_fail_action=2, @on_fail_step_id=-1, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'TSQL', @command=N'USE [PengellysWebsite] ALTER FULLTEXT CATALOG [fulltextCatalog] REORGANIZE ', @database_name=N'master' GO
Leave a Comment
Comments