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