Wednesday, August 22, 2012


 Query to find the registered and scheduled Jobs in Oracle DB


SELECT  job, log_user username, what, 
 TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') Next_Run, interval,
 TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_Run, failures, broken
FROM dba_jobs;

No comments:

Post a Comment

Oracle Database & Applications R12.2 Log file locations

Many times, we forget the path for the log files since there are too many.  Below is the list of frequently used log files which can help us...