SNAPSHOT can not refresh automatically

[jm]

I set up a master and snapshot site on 2 different machines.
snapshot site contains one refresh group with few simple snapshot tables.

so far, I only can manually "force" refresh the snapshot site.
using dbms_refresh.refresh('groupname');

could anyone tell me how to make the refresh automatically?

on master site:
repadmin (interval 6 sec)
dbms_defer_sys.schedule_purge (interval=>/*6:Secs*/ sysdate + 6/(24*60*60)

on snap**** site:
snapadmin (all 3 interval are 6 sec)
dbms_defer_sys.schedule_push(interval=>/*6:Secs*/ sysdate + 6/(24*60*60);
dbms_defer_sys.schedule_purge(inerval=>/*6:Secs*/ sysdate + 6/(24*60*60);
dbms_refresh.make(/*6:Secs*/ sysdate + 6/(24*60*60);
init.ora
job_queue_interval=10
job_queue_processes=2

[jsafi]

have you tried to use
dbms_snapshot.refresh('SNAP');?????????

[jm]

what is 'SNAP'? suppose put in group name, snapshot name/w method,..

Here is the result:

execute dbms_snapshot.refresh('SNAP');

ERROR at line 1:
ORA-23401: snapshot "SNAPADMIN"."SNAP" does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 140
ORA-06512: at line 1

[Gargantua]

After you make snapshot you should adjust how often you want the snapshot will be executing.
Example:
alter snapshot [snapshot] refresh next [time period];

Time period is in days, so if you need minutes (sysdate+5/1440) = 5 min.

After this snapshot will be execute every 5 minutes.
Nothing more you should set.

[LND]

make job_queue_processes=5..8

[sreddy]

See the following syntax for refreshing snapshots having a list of snapshots to refresh everyday at 4 am.

<font face=courier>
/* contains all the snapshots for refresh */
begin
dbms_refresh.make('xyzrod.xyzrod_ref',

'xyzrod.usps_suffix,
xyzrod.usps_abrev,
xyzrod.fips_country_code,
xyzrod.usps_state,
xyzrod.ems_msag_community,
xyzrod.pbc_saf',

trunc(sysdate) + 19/24, 'trunc(sysdate + 1) + 4/24');
end;
/
execute dbms_refresh.refresh('xyzrod.xyzrod_ref')
</font>

[Edited by sreddy on 02-08-2001 at 08:47 AM]

[Prof]

Are you sure Did you run catrep.sql? it is necessary.