sybase trigger sending email? 
Author Message
 sybase trigger sending email?

How can a sybase trigger send email?  
Please reply directly.
--

Member Services International



Tue, 11 Apr 2000 03:00:00 GMT
 sybase trigger sending email?

: How can a sybase trigger send email?  
: Please reply directly.

As things are today, you can't do that.  You would need an Open Server
application.  A trigger can invoke a remote procedure on another server
(an Open Server, for example).  And you can write your Open Server app
to do whatever you want, including send email or beep you ...

You could set a flag and poll for that.  When the flag is set, the polling
script or program can send email.  It's not an elegant solution, but it's
what many of us have resorted to because it can be built with existing
tools and utilities.

There is also the syb_sendmsg.  You'll find an excellent explanation of
how it works and what the short comings are in the Sybase FAQ at
http://reality.sgi.com/pablo/Sybase_FAQ/    You want Q7.8.

                                Hope this helps
                                Teresa Larson

     _________________________________________________________________
    /  Teresa A. Larson                 http://www2.ari.net/jmasino/ /
   /  Bell Atlantic                          Voice: (301) 282-0224  /
  /  13100 Columbia Pike, A-3-3              Fax:   (301) 282-9416 /

/________________________________________________________________/
                      #include <std_disclaimer>



Wed, 12 Apr 2000 03:00:00 GMT
 sybase trigger sending email?

you need an openserver to do this
u can make an rpc call to an openserver which can do this

there is an openserver sample program called utility.c which will do this



Quote:
> How can a sybase trigger send email?  
> --

> Member Services International



Wed, 12 Apr 2000 03:00:00 GMT
 sybase trigger sending email?

You may be able to do this is v11.5. It now has facilties for calling
'extended' stored procedures.
Gary

Quote:
>How can a sybase trigger send email?
>Please reply directly.



Wed, 12 Apr 2000 03:00:00 GMT
 sybase trigger sending email?

Adaptive Server 11.5 has extended stored procedures which can make a
standard system() call on Unix machines and access MAPI on NT boxes.
You can browse the documentation at http://sybooks.sybase.com/

                        -=- D. J.

: How can a sybase trigger send email?  
: Please reply directly.
: --

: Member Services International



Thu, 13 Apr 2000 02:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Sending an email by a trigger ??

2. sending email from a SQL trigger

3. Trigger to send email

4. How to send an email form sql trigger

5. Sending Email on a trigger....

6. Sending emails when a trigger fires ?

7. Sending email from trigger

8. Trigger sending an eMail

9. Trigger sending an eMail

10. Database trigger sending email

11. Trigger to send email message

12. trigger to send email


 
Powered by phpBB® Forum Software