sql for querying Process Flows' Schedules' Start Date and End Date

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is there a sql statement to query all Process Flow Schedules and the Schedules' Start Date and End Date values?

Environment

Release : 9.x

Component : APPLICATIONS MANAGER

Resolution

select so_module, aw_sch_start, aw_sch_end from so_job_table a, aw_module_sched b where a.so_job_seq=b.aw_job_seq and so_command_type='CHAIN';