Groups | Blog | Home
all groups > sql server full text search > december 2003 >

sql server full text search : can you create a population schedule with an sp?



cakewalkr7 NO[at]SPAM hotmail.com
12/6/2003 4:07:16 PM
I'm trying to write a sql install script so a client can just execute
the script in query analyzer and it will create all the tables, views,
fts catalog, etc. I've got everything working fine except I don't
know how to make it create a population schedule for the fts catalog.
John Kane
12/6/2003 6:21:02 PM
Geoff,
Yes, this is possible. You should create a test Full or Incremental
Population SQLServerAgent job via the FT Wizard using the pubs database and
authors table. Then in the Enterprise Manager open up the Management folder
and SQL Server Agent folder and right-click on the Jobs icon. Select "All
tasks" and click on "Generate SQL script" and type in a file name or click
on Preview to get the SQL code for the Full or Incremental Population
SQLServerAgent job. You can modify this code as necessary to add the job,
job steps and job schedules to any SQL Server.

Regards,
John




[quoted text, click to view]

AddThis Social Bookmark Button