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 […]
