full text index schedule

[amiw]

I ran a full text index which worked fine. Now I've done an edit set up a schedule to run a new full-text index catalog schedule - "Full population"
it's enabled to occur every day at 00:00:00

Problem is the schedule isn't running, any ideas?

 

[mrdenny]

The schedule creates a job. That job is what starts the population. Make sure that SQL Agent is running. Are there any errors from the job?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[amiw]

How do I make sure the SQL Agent is running? or check if there are any errors for the job?

 

[JayKusch]

Open Enterprise Manager (EM) and drill down to Management..SQL Server Agent(SSA).

There should be a green arrow on the SSA. If not, right-mouse click the SSA icon and then choose Start.

To check a job, drill futher into SSA and click on the Jobs icon. In there you will see a list of jobs that are running on your server for SQL Server.

Right-click on the Full Text Job and choose "View Job History". Once the History open, check the box at the top that says "Show Step Detail". Now you can see what happended withing each job at a step level.

Thanks

J. Kusch