| Reg Domaratzki \(iAnywhere Solutions\) 2005-07-20, 9:23 am |
| Can you define what you mean by "just stopped" ?
If dbremote shut down because it lost access to the messaging system, you
can use the sp_hook_dbremote_end
stored procedure to send an e-mail just
before shut down.
If dbremote GPF'ed, you'll need to do something at the OS level to check on
the status of the process you've started.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<Sunil DHURVE> wrote in message news:42dda70b.4c68.1681692777@sybase.com...
> Hello I am using v 9.0.2.2451 with one consolidate and 3
> remote dbs. yesterday dbremote at consolidated db just
> stopped and we didnt know till next day i want to know is
> there any way i can fire a event which sends an email saying
> dbremote is not working from last 2 hours or so.
> i think i can query some system tables and the connected
> users...
> thanks for your help
> sunil
|