SQL Server Full Text index populating

0 comments
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
SQL

Comments


Leave a Comment