Broken snapshots - repair

exec dbms_job.broken(218, FALSE, NEXT_DAY(SYSDATE, 'SUNDAY'));
commit; --- DONOT FORGET TO COMMIT

This will make the broken job again active, setting the next schedule date.

If you want to execute the job immediately to refresh the shapshot, use dbms_job.run(218)