List all running jobs

SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60 SET LINESIZE 300 SET VERIFY OFF SELECT a.job “Job”, a.sid, a.failures “Failures”, Substr(To_Char(a.last_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “Last Date”, Substr(To_Char(a.this_date,’DD-Mon-YYYY HH24:MI:SS’),1,20) “This Date” FROM dba_jobs_running a /

Oracle, SQL, Sqlplus, ,

Find the last JOB run status

set lin 300 col JOB_NAME format a30 col STATUS format a15 col ADDITIONAL_INFO format a100 select JOB_NAME,STATUS,ADDITIONAL_INFO from dba_scheduler_job_run_details where log_id in(select max(log_id) from dba_scheduler_job_run_details where job_name like upper(‘&job_name’));

SQL