7.16 Mark the OWBSYS Job as Broken

  1. Query for the OWBSYS jobs running on Oracle Database 19c:
    select job,broken from dba_jobs where schema_user='OWBSYS' and broken='N';
    It returns the DBMS job with the OWBSYS user.
  2. For each of the DBMS job returned in the previous step, execute the following:
    begin
    dbms_job.broken(job,true);
    commit;
    end;
    /
    Where, job is the DBMS job returned in step 1.