3 responses to “How to find jobs currently running or history about the jobs?”

1. 

   sundar

   August 26, 2016

   what is the functionality of sql loader ? how it internally works

   LikeLike

   Reply
2. 

   jmarquez1974

   December 13, 2017

   Reblogged this on jmarquez1974 and commented:
   How to find jobs currently running or history about the jobs?
   Alex Lima / November 26, 2008
   In 10g one can find the jobs that are currently running by querying the following view

   SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs;

   Also one can use the following view to find the history details of job that has run.

   SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;

   To find the jobs that haven’t succeeded
   SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status ‘SUCCEEDED’;

   LikeLike

   Reply
3. 

   igre

   June 1, 2020

   if you don’t have dba permision ? dba_scheduler_running_jobs

   LikeLike

   Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.