Antoine_Sauteron_1266

Finding out if a process or an Agent is running

Discussion created by Antoine_Sauteron_1266 on Dec 1, 2016
What are the table names which provide information related  to agents whether they are running or not for Automation engine Agents (Master, OAE Remote agents) and Communication processes and Work processes (Whether these are running or not ) ?

1 - You can use this kind of query to get the results:

SELECT OH_Name,
(CASE HOST_Active
     WHEN '0' then 'inactive'
     WHEN '1' then 'running'
END)
FROM OH, HOST
WHERE OH_Idnr = HOST_OH_Idnr
AND OH_Otype IN ('HOST', 'SERV')
AND OH_Name NOT LIKE '<%>'
Which will return this (here in a SQLI variable object, but it can be done from a regular DB client as well):

0g1hblmr64o8.png


2 - However you may as well use script functions for that purpose.

 

:SET &AGENT_STATUS# = SYS_HOST_ALIVE("MyAgent")

 

:SET &SRV_STATUS# = SYS_SERVER_ALIVE("AE#WP001")

Outcomes