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;
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'));
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