DBA SCHEDULER JOBS

To kill:------


 EXEC DBMS_JOB.REMOVE(164);







TO check a job:----

 select * from dba_jobs_running;

 desc dba_jobs;

select JOB_NAME,NEXT_RUN_DATE,LAST_RUN_DURATION,LAST_START_DATE from DBA_SCHEDULER_JOBS where owner='IROC'

select job,WHAT,LOG_USER,PRIV_USER,FAILURES from dba_jobs where broken = 'Y' or failures > 0;






$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$4
Additional information about job:-------------------
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$




select * from DBA_SCHEDULER_JOBS; --displays information about all Scheduler jobs in the database
select * from USER_SCHEDULER_JOBS; --displays information about the Scheduler jobs owned by the current user. This view does not display the OWNER column.
select * from user_jobs; --or ALL_JOBS/DBA_JOBS
SELECT JOB_NAME,STATUS,ADDITIONAL_INFO FROM  DBA_SCHEDULER_JOB_RUN_DETAILS  WHERE JOB_NAME = '';
SELECT WINDOW_NAME, RESOURCE_PLAN FROM DBA_SCHEDULER_WINDOWS WHERE ACTIVE='TRUE';
SELECT * FROM V$RSRC_PLAN;
SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;
SELECT log_id, to_char(log_date, 'DD-MON-YY HH24:MM:SS') timestamp,
   window_name, operation FROM DBA_SCHEDULER_WINDOW_LOG;
SELECT LOG_ID, WINDOW_NAME, ACTUAL_START_DATE, ACTUAL_DURATION
  FROM DBA_SCHEDULER_WINDOW_DETAILS;


#List info for All Jobs Currently Running
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
/