Automic Workload Automation

  • 1.  What are the table names for Automation engine Agents (Master, OAE Remote agents) and CP'S AND WP'S

    Posted Dec 01, 2016 04:39 AM
    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  ?


  • 2.  What are the table names for Automation engine Agents (Master, OAE Remote agents) and CP'S AND WP'S

    Posted Dec 01, 2016 05:12 AM
    Deepak,

    I think, in that case, the system overview should provide you that data in the optimal way.

    While the information if a Agent is active could (!!) be found within the HOST Table (HOST_ACTIVE),
     the status of CP and WP Processes can not be determined that easily via the database, since these processes do report into the MQ Tables and they are shared from all active WP and CP Processes (except MQCP Tables but i really dont recommend to touch them without order from technical support to do so regarding to an active incident)

    if you really want to determine if an agent is active or not via DB, you can ping the HOST Table, but the recommended and more comfortable way would be to do that via the system overview or with the regarding script command (SYS_HOST_ALIVE)


  • 3.  What are the table names for Automation engine Agents (Master, OAE Remote agents) and CP'S AND WP'S

    Posted Dec 01, 2016 01:29 PM
    Additionally, in case it wasn't seen, there was a recent article which goes into more detail on this:

    https://community.automic.com/discussion/8041/finding-out-if-a-process-or-an-agent-is-running


  • 4.  What are the table names for Automation engine Agents (Master, OAE Remote agents) and CP'S AND WP'S

    Posted Dec 06, 2016 03:18 PM
    You can use JMX as I suggested here: https://community.automic.com/discussion/8059/monitor#latest
    , not only can you see the status of the Agent but you can also start and stop it though this.
    If you are interested in what tables do what you can look at <Automic Engine Image>/Automation.Platform/db/_structure/HTML/index.htm