Scripts to check DBMS jobs running
======================================
select job_name, session_id, running_instance, elapsed_time, cpu_used
from dba_scheduler_running_jobs;
======================================
select job_name, session_id, running_instance, elapsed_time, cpu_used
from dba_scheduler_running_jobs;
if you want to stop job, you can stop by using below command (or) kill by using SID
===============================================================
exec DBMS_SCHEDULER.stop_JOB (job_name => '<JOB_NAME>');
No comments:
Post a Comment