| Reg Domaratzki \(iAnywhere Solutions\) 2005-07-22, 9:26 am |
| There are three hooks the fire on the client when errors occur.
sp_hook_dbmlsync_dow
nload_com_error
sp_hook_dbmlsync_dow
nload_sql_error
sp_hook_dbmlsync_dow
nload_fatal_sql_erro
r
One (or more) of this hooks should fire when you want to capture the error
you are interested in, and you could call xp_startmail (or xp_startsmtp),
xp_sendmail, and then xp_stopmail (or xp_stopsmtp) to send an e-mail
notification.
--
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
"MJN" < SpamFilterOnlychuck1
rar@yahoo.com> wrote in message
news:42df88a5@forums
-1-dub...
> Trying to find out the easiest way to send an email alert if the client
> mlsync fails thru the cause of an error or if the engine shuts down. I
know
> of a tool that monitors a service and that is fine if the service shuts
down
> but will not do me any good if mlsync just fails thru an error and then
> keeps on hovering till the next scheduled upload..
> Any suggestions or tools?
>
> ASA 9.02
>
>
|