2 Replies Latest reply on Dec 27, 2016 9:17 PM by Valentina G.

    Overdue Jobs of SYS.DB_SPACE_HISTORY; in Oracle E-Business Suite

    Valentina G.

      We recently view messages of overdue jobs of SYS.DB_SPACE_HISTORY, but I don't. create job SYS.DB_SPACE_HISTORY;

      Can you any note about jobs? How know who create of job?

       

      SQL> alter session set nls_date_format='HH24:MI:SS';

       

      Session altered.

       

      SQL> select job,failures,last_sec,next_sec,total_time,sysdate from dba_jobs where FAILURES=0 ;

       

             JOB   FAILURES LAST_SEC NEXT_SEC TOTAL_TIME SYSDATE

      ---------- ---------- -------- -------- ---------- --------

           38698          0 20:00:01 00:00:00          2 21:50:14

      SQL>

       

      SQL> select job, schema_user, what from dba_jobs where FAILURES=0 ;

             JOB SCHEMA_USER                    WHAT

      -----------------------------------------------------------------------------------

           38698 SYS                            SYS.DB_SPACE_HISTORY;

       

       

      SQL>

       

      Regards,