DBA_SCHEDULER_JOBS.sql

-- see scheduled jobs
SELECT * FROM DBA_SCHEDULER_JOBS
WHERE 1=1
AND job_name LIKE 'PRC_RFRSH_OCI_COST_DATA_JOB%'

-- see previous jobs
SELECT * FROM DBA_SCHEDULER_JOB_LOG
WHERE 1=1
AND job_name LIKE 'PRC_RFRSH_OCI_COST_DATA_JOB%'

-- see previous job details
SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE 1=1
AND job_name LIKE 'PRC_RFRSH_OCI_COST_DATA_JOB%'