materiaized view not running

Hi,

I have 6 materialized views setup to run daily but only 2 are running. Within the database, there are about 11 other scheduled jobs (13 total) and the job_queue_process is set to 12. The problem I'm having is only 2 of my 6 materialized views are showing up in dba_jobs and hence, are running. When I query user_snapshots the NEXT column is blank for the 4 that are not in dba_jobs.

Can someone explain to me what is happening with 1) the jobs not being run, and 2) the NEXT column being blank.

Thanks
Leonard

Have you tried something like ...

Code:

---

Alter Materialized View
  MY_MV
Refresh
  Next  Trunc(SysDate,'DD')+1;

---