oracle Scripts to check DBMS jobs running

Scripts to check DBMS jobs running
======================================



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

View running queries in postgresql

 View running queries in postgreSQL: SELECT * FROM pg_stat_activity;