Oracle Database – How to fix broken database jobs

How to Fix broken DBA 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 APPUSER/password

SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs

JOB        SCHEMA_USER                    B WHAT
---------- ------------------------------ - ----------------------------------------
1          APPUSER                        N db_backup.p$_backup_p(1);
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s