Tuesday, June 3, 2014

Script to find in oracle 10g jobs_running

SET LINESIZE 200

COLUMN owner FORMAT A20

SELECT owner,
       job_name,
       running_instance,
       elapsed_time
FROM   dba_scheduler_running_jobs
ORDER BY owner, job_name;

No comments:

Post a Comment