Angie Leung wrote:
I am preparing a dedicated PC to serve as the DAS. This PC will be located in the equipment room. When the DAS is down, I would like a message to send to the administrator automatically. How can I go about it? Please advise.
We actively do this currently via e-mail notification. In order to do it, you basically need to create an application that keys off of the value in M_TMS_N_BEGINTIME in the OBJ_M_TIMESTAMP table where the field M_TMS_N_ENTITYID is equal to the M_ACTOR_N_ID value in the OBJ_M_ACTOR table corresponding to your document agent. This value is the number of seconds since December 15th, 1970.
This value is updated by the Document Agent periodically and is used to determine if another document agent comes up in primary or console mode. The frequency of the update is determined by the refresh time settings on the document agent. To determine if the document agent is down, consider your refresh time and check the last update time. If the last update time is not close to the current time - refresh time, you can consider the Document Agent down.
In our own environment, this id done in PL/SQL in conjunction with some utilities we have to make e-mail/paging requests from PL/SQL. It could be done, however, in virtually any language that can establish a connection to the database and perform an e-mail/page.
FYI,
Bob Molby
GE Lighting
Listserv Archives (BOB member since 2002-06-25)