I had the same problem, askTom to the rescuse need to create a function which returns an interval http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:388480262167#49098749303720 On 10/26/05, t_adolph@xxxxxxxxxxx <t_adolph@xxxxxxxxxxx> wrote: > > Hi all, > > I'm trying to setup snapshots to run every 15 minutes during working > hours, > else hourly. I'm ignoring weekends for now,... >