How to fix broken database jobs


SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs
JOB SCHEMA_USER B WHAT
---------- ------------------------------ - ----------------------------------------
 47 ANAR Y send_bps_notifications1;
1 rows selected.
SQL> exec dbms_job.broken(47,FALSE);
PL/SQL procedure successfully completed.
SQL>connect ANAR/password
SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs
JOB SCHEMA_USER B WHAT
---------- ------------------------------ - ----------------------------------------
1 ANAR N send_bps_notifications1;
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

%d bloggers like this: