How to get the details about scheduler jobs

Query to know about job details:

========================

set lines 300

col owner for a10

col JOB_NAME for a30

col LAST_RUN_DURATION for a30

col LAST_START_DATE for a35

col NEXT_RUN_DATE for a35

select owner,JOB_CREATOR,job_name,LAST_START_DATE,LAST_RUN_DURATION,NEXT_RUN_DATE,state,FAILURE_COUNT "F_C" from dba_scheduler_jobs where job_name=upper('&job_name');

Input: Job Name

Query to know the current running jobs:

==============================

col ELAPSED_TIME for a30

set lines 300

select JOB_NAME,OWNER,SESSION_ID,ELAPSED_TIME,RUNNING_INSTANCE from dba_scheduler_running_jobs;

Query To know the job history details:

=============================

SET LINES 250

SET PAGES 1000

col LOG_ID format 9999999

col JOB_NAME format a30

col status format a15 trunc

col LOG_DATE format a30

col ADDITIONAL_INFO format a50

col RUN_DURATION for a30

SELECT log_id, job_name, status, to_char(log_date,'DD-MON-YYYY HH24:MI') log_date,RUN_DURATION,ADDITIONAL_INFO

FROM dba_scheduler_job_run_details WHERE

job_name='&job_name' and

(log_date) > (sysdate - &Duration) ORDER BY LOG_DATE;

Input: Job name and history duration(in days)