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...