Tuesday, January 13, 2009

script for 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