The following SQL select statement will display jobs, their schedules and the associated user assigned to the schedule searched by user.
select jt.so_module, sch.aw_sch_name, sut.so_user_name
from aw_module_sched sch, so_job_table jt, so_user_table sut
where sch.aw_user_seq = sut.so_user_seq
and sch.aw_job_seq = jt.so_job_seq
and sut.so_user_name like '%SQLOPER%';
*Note you will need to change SQLOPER to the specific user you are wishing to query for.