No, you understand and are helping me immensely Kate,
OK I do have a job running as you suggest. So in about 20 days all should
As far as setting up the vaccum to run on a schedule can that be done
through NSCONTROL UPDATE when the history backlog is cleaned out. I have
always configured the vaccum schedule as part of an initial install and not
after the fact.
> i was thinking that it would be best to call the vacummer manually and
> not create a schedule until you have the dross cleaned out so you can
> control the resource usage. you can execute the vacuumer proc from tSQL
> with a restriction on the quantums to be processed (see BOL) .this
> could then be wrapped in an agent job to repeat periodically but
> allowing other processing to go on between times.
> if i have totally misunderstood the question then do post back.
> Kate MBCS
> Alert Technologies
> Get your notification services implementation going in minutes not
> weeks ......