Snapshot Refresh Question

Hi folks,

I've created a snapshot with the following steps.

1. created dblink to master database
2. create snapshot log on master database table, something like... create snapshot log on TAB_NAME tablespace DATA storage(initial 128K next 50K pctincrease 0) pctfree 5 pctused 90;
3. create snapshot on DB to hold snapshot, something like... create snapshot SNAPNAME pctfree 5 tablespace SNAP storage (initial 1024K next 128K pctincrease 0) refresh fast start with sysdate next sysdate+1 as select * from TAB_NAME;

I can refresh the snapshot manually and successfully using...

        execute DBMS_SNAPSHOT.REFRESH('owner.snapname','?');

At least i think its successful as new data gets brought across. But when i look at last_refresh from DBA_SNAPSHOTS, it always contains "01-Jan-1950".

Problem is that snapshot does not seem to refreshing automatically. I've got job_queue_processes = 3, job_queue_interval = 60 in my init.ora.

Can anybody tell me what i'm not doing right, what i'm missing? Thanks!

Regards,
Calvin

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGPfreeware 6.0.2i

mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1 gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+ 6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1 uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768 cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4 gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1 SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2 tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw== Received on Mon May 08 2000 - 17:05:30 CDT