Scheduled Job is failing with database error

The problem I’m having

I have a running job that loads new data from our staging layer to raw layer, it was running absolutely fine until recently the job started failing with this error "Encountered an error: Database Error could not open relation with OID

The context of why I’m trying to do this

I trying to load new data from staging layer to raw layer incrementally but model fails sometimes

What I’ve already tried

I have tried changing the other jobs so that this job does not concide with the other jobs but still this issue persists

Some example code or error messages


Encountered an error:
Database Error
  could not open relation with OID xxxxxxx

Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML!