Re: Index Population Schedule has no Tasks

Tech-Archive recommends: Fix windows errors by optimizing your registry

If you are trying to schedule a reorganize you can do it like this

ALTER FULLTEXT CATALOG catalog_name REORGANIZE

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Todd C" <ToddC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B658D62F-C043-4A2E-9509-765AE656999D@xxxxxxxxxxxxxxxx
Using SQL 2005 and SSMS, I created a Full Text catalog on a table. Also
using
the wizard, I set up a scheule to optimize it. When I examine the SQL
Agent
job that got created as a result of the wizard, the job has no Steps
defined.

This always happens. I get FT optimizing jobs with no steps. What am I
missing?

Is there a good TSQL script that I can execute as a step in the job?
--
Todd Chittenden


.