Database Utilities (MOSC)

MOSC Banner

DBMS_SCHEDULER, unable to find details of a scheduled job that is correctly running

Hi all,

in my database (old activity) there is a job but I'm not able to identify details about how it has been created.

I can see details of executions:

select OWNER, JOB_NAME, STATUS, REQ_START_DATE from dba_scheduler_job_run_details where JOB_NAME='DATABASEGROWTH'

OWNER                         JOB_NAME            STATUS                        REQ_START_DATE

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

OSUSER_ORACLE                 DATABASEGROWTH      FAILED                        21-GIU-21 00:00:00,089137 EUROPE/PARIS

OSUSER_ORACLE                 DATABASEGROWTH      FAILED                        10-LUG-21 00:00:00,068739 EUROPE/PARIS

OSUSER_ORACLE                 DATABASEGROWTH      FAILED                        02-LUG-21 00:00:00,142215 EUROPE/PARIS

OSUSER_ORACLE                 DATABASEGROWTH      FAILED                        11-LUG-21 00:00:00,244094 EUROPE/PARIS

OSUSER_ORACLE                 DATABASEGROWTH      SUCCEEDED                     14-LUG-21 09:52:37,666661 EUROPE/PARIS

OSUSER_ORACLE                 DATABASEGROWTH      SUCCEEDED                     14-LUG-21 10:07:22,322777 EUROPE/PARIS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center