2 Replies Latest reply on Oct 27, 2019 12:12 PM by Beauty_and_dBest

    Database Broken Jobs

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

       

      Hi ALL,

       

      We have found broken jobs in our database.

      How do we fixed it?

       

      -We can find out the failed jobs and Broken jobs details with the help of the Below query:

      spool job_broken

      select job||' '||schema_user||' '||Broken||' '||failures||' '||what||' '||last_date||' '||last_sec from dba_jobs;

      spool off

      JOB||''||SCHEMA_USER||''||BROKEN||''||FAILURES||''||WHAT||''||LAST_DATE||''||LAST_SEC
      225 APPS N 0 declare errbuf varchar2(4000); retcode varchar2(4000); begin WF_BES_CLEANUP.CLEANUP_SUBSCRIBERS(errbuf, retcode); end; 10/21/2019 14:58:18
      104 APPS N 0 FND_SVC_COMPONENT.EXECUTE_REQUEST (p_component_request_id => 10000); 10/20/2019 21:20:53

       

       

       

      Please help....

       

       

      Kind regards,

      jc