Daily Archives: April 30, 2015

How to fix broken database jobs


SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs JOB SCHEMA_USER B WHAT ———- —————————— – —————————————- 1 APPUSER                   Y db_backup.p$_backup_p(1); 1 rows selected. SQL> exec dbms_job.broken(1,FALSE); PL/SQL procedure successfully completed. SQL>connect user/password SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs JOB SCHEMA_USER B WHAT ———- —————————— – —————————————- 1 APPUSER         […]