Friday, August 3, 2018

how to check the database jobs running from scheduler ?

Jobs running in database:
set linesize 250
set pagesize 250
column JOB_NAME format a30
column CPU_USEDformat a20
column ELAPSED_TIME format a30
SELECT job_name, session_id, running_instance, elapsed_time, cpu_used FROM dba_scheduler_running_jobs;


For an owner define here and check if jobs is true to run: 

column REPEAT_INTERVAL format a30
column OWNER format a10
column NEXT_RUN_DATE format a30
set linesize 250
set pagesize 250
select owner, job_name, job_class, enabled, next_run_date, repeat_interval from dba_scheduler_jobs where owner = decode(upper('&1'), 'ALL', owner, upper('&1'));

Status is running:

SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status='RUNNING';

Status is succeeded today:
SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details where status = 'SUCCEEDED'  order by actual_start_date; 

No comments:

Post a Comment