Gabor_Szilagyi_7654

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 Jessica_Isaacson_255
You could find the list of jobs assigned to a specific host
by querying the DB with the following statement:

-------------
select * from OH, JBA
where OH_IDNR = JBA_OH_IDNR
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:
..\db\_structure\HTML\index.htm

Outcomes