Search notes:

Oracle: DBA_JOBS

All jobs in the database.
select
  owner_name,
  job_name,
  operation,
  job_mode,
  state,
  degree,
  attached_sessions,
  datapump_sessions
from
  dba_datapump_jobs
order by
  owner_name,
  job_name;
Github repository Oracle-Patterns, path: /Installed/data-dictionary/datapump/jobs/show.sql

See also

dba_jobs_running
all_jobs is a special synonym for user_jobs.
dba_scheduler_jobs

Index