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