Automic Community

How to find a list of jobs, schedules and the associated user assigned to schedule?

  • 1.  How to find a list of jobs, schedules and the associated user assigned to schedule?

    Posted 06-13-2018 03:51 PM

    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.