Finding out if a process or an Agent is running

[Legacy User]

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):

https://us.v-cdn.net/5019921/uploads/editor/fe/0g1hblmr64o8.png" width="493">

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

• Check the status of an Agent withSYS_HOST_ALIVE
  

 

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


 

• Check the status of a server process with SYS_SERVER_ALIVE

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