|
Home > Archive > MS SQL Server > January 2006 > incremental Population not starting
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
incremental Population not starting
|
|
|
| Running on Sql Server 2000, I have a catalog set to do an incremental
populate every 5 minutes each day.
But when I make a change to a record and do a search on it, it doesn't find
it, even after about 20 minutes. But if I manually do the incremental
population, it then works.
Why wouldn't the schedular work?
Thanks,
Tom
| |
| David Gugick 2006-01-25, 3:24 am |
| tshad wrote:
> Running on Sql Server 2000, I have a catalog set to do an incremental
> populate every 5 minutes each day.
>
> But when I make a change to a record and do a search on it, it
> doesn't find it, even after about 20 minutes. But if I manually do
> the incremental population, it then works.
>
> Why wouldn't the schedular work?
>
> Thanks,
>
> Tom
Are you saying you are using SQLAgent to schedule a task to run every 5
minutes and it is not working or is not running. Is the job showing any
execution errors? If not, try using Profiler to see what SQLAgent is
running.
--
David Gugick
Quest Software
www.quest.com
|
|
|
|
|