Ultimate

X_JOB_REFRESH_VIEW_INVALID

Means

a refreshView declaration names no materialized view it can refresh

Typical cause

refreshView() was given an entity that is not declared view: { sql, materialized: true }, or concurrently: true over a view with no unique index

Fix

refreshView({ name, view, concurrently: false }) — or declare the view materialized: true with a .unique() column

Listed under Jobs

This page as markdown