materiaized view not running
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.
Have you tried something like ...
Alter Materialized View
Click Here to Expand Forum to Full Width