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;