SQL statement to list all objects/activities with activated breakpoint

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

SQL statement to list all objects/activities with activated breakpoint

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

If there is a need to list all objects/activities with activated breakpoint you could use the following sql statements:

List all objects with breakpoints:
select oh.oh_name, oh.OH_Client, o2.JPP_Object from oh,(select jpp_oh_idnr,JPP_Object from JPP where JPP_Active in (2,3)) o2 where oh.OH_Idnr=o2.JPP_OH_Idnr

List all activities (activity window) with breakpoints:
select ah.ah_name, ah.AH_Client,o2.EJPP_Object from AH,(select EJPP_Object, EJPP_AH_Idnr from EJPP where EJPP_Active in (2,3)) o2 where ah_idnr =o2.EJPP_AH_Idnr