Is there any query to find the list of jobs configured or assigned in specific host?

Discussion created by Gabor_Szilagyi_7654 on Jan 24, 2017
Latest reply on Jan 25, 2017 by JessicaIsaacson603938
You could find the list of jobs assigned to a specific host
by querying the DB with the following statement:

select * from OH, JBA
and OH_DeleteFlag = 0
and OH_OType = 'JOBS'
and JBA_HOSTDST = 'specific_agent_name'

OH - Object Header table contains all objects
JBA – JOBS Attribute table
OH_IDNR and JBA_OH_IDNR are primary keys of the two tables
(OH_DeleteFlag = 1 object is deleted)

You may find details on the DB tables in the DB Folder: