Is there a sql query to check which Process Flows has an active Schedule?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is there a sql query to check which Process Flows has an active Schedule?

Environment

Release : 9.4

Resolution

Hello Abhay,

There are 2 available REPORTS that provide information about active Jobs or Schedules.

UC4_SCHEDULED_JOB_SUMMARY
UC4_SCHEDULED_JOBS

Additionally, a simple sql that can be run to see what Process Flows have an active schedule is:

SELECT so_module as "Process Flow", aw_sch_name as "Schedule Name", aw_active as Active
FROM so_job_table, aw_module_sched
WHERE so_job_table.so_job_seq=aw_module_sched.aw_job_seq
AND so_command_type='CHAIN'
AND aw_active='Y'
ORDER by so_module;