Re: Snapshots

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/07/20
Message-ID: <8l6rbf$lg9$1@news.bentley.com>#1/1

Not sure if this is your problem...

As I recall, if you specify the refresh interval to be (sysdate + 1/24) for example, and the job takes 15 minutes to execute, the interval is calculated off of the END TIME of the previous job run. Meaning each time it starts it will be starting 15 minutes later. That adds up, over time, of course..

You have to specify something like this for the interval instead:

next_day (sysdate, 'thu') + 15/24

HTH,
Tom Best

<unixsysad_at_my-deja.com> wrote in message news:8l51gm$7m6$1_at_nnrp1.deja.com...
> I am wondering what would cause snap shot degradation (time for refresh
> of snap shot) besides network or size of the snap shot? I work with
> snapshots on a daily basis, getting a snapshot from the east coast to
> the west coast, and sometimes it works within 30 minutes, at other
> times it takes hours. Can anyone help?
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 20 2000 - 00:00:00 CDT