Playing with Oracle Jobs

queries-oracle-jobs.sql

-- shows running jobs
SELECT JOB_NAME, STATE
FROM   USER_SCHEDULER_JOBS; -- DBA_SCHEDULER_JOBS

-- shows logs of completed jobs
SELECT *
FROM   USER_SCHEDULER_JOB_LOG -- DBA_SCHEDULER_JOB_LOG
ORDER BY LOG_DATE DESC;

-- shows details of completed jobs
SELECT *
FROM   USER_SCHEDULER_JOB_RUN_DETAILS -- DBA_SCHEDULER_JOB_RUN_DETAILS
ORDER BY LOG_DATE DESC;

--
-- Oracle Configuration
--

-- shows how many jobs Oracle supports in parallel
select value from v$parameter where name='job_queue_processes';

-- configures the max number of jobs in Oracle
alter system set job_queue_processes = 8;