materiaized view not running

[leonard905]

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

[slimdave]

Have you tried something like ...

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