Re: Refreshing materialized viws

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 03 Mar 2005 13:33:41 +0100
Message-ID: <d0702r$aqh$1@news5.zwoll1.ov.home.nl>

leszek wrote:
> Hi
> I created materialized view. It have been refreshed once for 5 minutes, but
> i would in order to refreshing have been stopped between 11 PM and 5 AM . In
> refresh clause I don't see that posibiliy. Can you help me ?
>
> regards
> leszek
>
>
>

No.
You can tell jobs when to run, not when not to run.

Why do you want it stopped, anyway - is that a backup window? If so, you will end up with a bunch of failed jobs, that can be cleared easily - replication will continue after 5 AM

-- 
Regards,
Frank van Bortel

Received on Thu Mar 03 2005 - 06:33:41 CST