How to send SMTP e-mail from SQL query

[gandalf33]

Greetings,

I'm using Sybase ASA 7.0.4; I know about the xp_startmail(), xp_sendmail() and xp_stopmail() procedures, but as I am aware, they are using MAPI; I want to send a SMTP e-mail.

I am creating a simple EVENT that checks if the disk space is below 10% and if yes, it e-mails the admin.

I need the help of anyone very much.

Milan

 

[gandalf33]

I've managed to use the xp_startsmtp, xp_sendmail and xp_stopsmtp functions properly to send an e-mail from SQL query.

The problem is, it's in ASA 9 only. ASA 7 does not support xp_startsmtp and xp_stopsmtp...

If you know at least some sort of solution, please reply to this thread. Thank you very much.

Milan