O'Reilly logo
  • mukhtar_7 thinks this is interesting:

select  mj.job_owner, mj.job_name,
decode(mj.is_library, 1, 'JOB_LIBRARY', 0, 'JOB_ACTIVITY')
from sysman.mgmt_job mj
order by mj.job_owner, mj_job_name;

From

Cover of Expert Oracle Enterprise Manager 12c

Note

select mj.job_owner, mj.job_name,
decode(mj.is_library, 1, 'JOB_LIBRARY', 0, 'JOB_ACTIVITY')
from sysman.mgmt_job mj
order by mj.job_owner,mj.job_name;