This can get you started. It is an old query, and i have not used it recently. I know tables are moving to xml format, so this may be out dated. It is only getting chains/processes, it is not getting Jobs.
-------------------------------------------------------------
-- Processes with an active schedule with either a blank agent
-- or blank requestor.
-------------------------------------------------------------
SELECT a.so_module "Process",
b.aw_sch_name "Schedule Name",
b.aw_agent_seq "Agent",
c.so_user_name "Requestor Name",
c.so_db_login "Requestor Login"
FROM appworx.so_job_table a,
appworx.aw_module_sched b,
appworx.so_user_table c
WHERE a.so_command_type = 'CHAIN'
AND a.so_job_seq = b.aw_job_seq
AND b.aw_active = 'Y'
AND (b.aw_agent_seq IS NULL OR b.aw_user_seq IS NULL)
AND (b.aw_user_seq = c.so_user_seq)
ORDER BY a.so_module;
------------------------------------------------
Christopher J. Mills
Assistant Director
Administrative Computing
Binghamton University
Binghamton NY, 13902-6000
607-777-6832
http://www2.binghamton.edu/