• Locked Locked
  • Replies 3 replies
  • Subscribers 13 subscribers
  • Views 4058 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Stat Central Agent Monitor

thomas shaw
over 5 years ago

Hi,

I am going to creating a Stat Central Agent monitor and wondering the best way to determine if the Stat Central Agent is down.  It will be a shell script that will execute from the Stat Central Agent server. The way I am thinking to monitor is check if the Stat Central Agent process is running from the operating system.  A 2nd check is to query the Stat Merc_Wake table where column agent_type is 'S' and column update_dt has not been updated in the last hour.  Will include a 3rd check against the Stat Central Agent log greping for connection errors when the 2nd test fails.  The monitor will then trigger an email when it detects those conditions.  Has anyone else created a Stat Central Agent monitor?  If yes, what conditions do you use to determine if the Stat Central Agent  is "Down"?  Also let me know any other way I can check the Stat Central Agent.

Let me know.

Thanks.  Tom

  • over 5 years ago

    Hi Tom,

    Welcome back Tom.

    You will need to monitor the MERC_WAKE table updated timestamp.

    Agent Type S - is for service domain

    Agent Type 0 - is for Oracle agent

    I believe you had set this up before using the Run Operating System Cmd job in Stat. You can probably write your own script to monitor this table and email yourself if and when the agent timestamp hasn't been updated. Unfortunately I don't know anyone who set this up besides you :)

  • over 5 years ago

    Hi,

    We set one up using the stat_agent table a few years ago. I don't fully recall why we used the stat_agent table over the merc_wake table; I think the wake table was still incinerating but the agent table stopped.  When we had a count of 1 an email would kick out using a third party product.  Since the STAT agent has become more stable we stopped using the script, but this worked well for us.  Hope this helps.

    select count(*) from stat_agent
    where agent_descr= 'Central Agent'
    and last_update_dt < sysdate - interval '20' second;

  • over 4 years ago in reply to tim.rogers

    Hi Tim,

    Thanks for the reply.  I think either table would work but thinking I will use the Merc_Wake table.