Answers for "oracle it jobs"

oracle list jobs

SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER NOT IN ('SYS')
ORDER BY ENABLED, OWNER, JOB_NAME;

-- Running jobs:
SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
	ELAPSED_TIME, CPU_USED 
FROM DBA_SCHEDULER_RUNNING_JOBS
ORDER BY OWNER, JOB_NAME;