Database Scripts

Beta
 Log In    |   Sign Up

Oracle : Find Schedules For Running Jobs

Added on Apr-09-2012 by tonyreg
For Oracle

Tags : jobs

This will output the scheduler info for any running jobs.

Versions

Oracle 10g

DOWNLOAD

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;

    

Report Script

blog comments powered by Disqus