Home » SQL & PL/SQL » SQL & PL/SQL » email on job start/complete (oracle 10g,xp)
email on job start/complete [message #582834] Tue, 23 April 2013 00:29 Go to next message
ashwanth77
Messages: 94
Registered: April 2013
Location: India
Member
I have a table with procedure name & status msg(ie.start,complete).The requirement is once the procedure starts,an email should be sent with the list of procedure that has started.
Re: email on job start/complete [message #582837 is a reply to message #582834] Tue, 23 April 2013 00:46 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
what about sending a mail using utl_mail/utl_smtp from the trigger whenever the status msg in the table changes?

regards,
Delna
Re: email on job start/complete [message #582843 is a reply to message #582837] Tue, 23 April 2013 01:46 Go to previous messageGo to next message
ashwanth77
Messages: 94
Registered: April 2013
Location: India
Member
How can i do this using a trigger,sorry im a newbie .i know how to send an email using utl_smtp/utl_mail package.any samples?
Re: email on job start/complete [message #582847 is a reply to message #582843] Tue, 23 April 2013 02:05 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Google for 'UTL_MAIL Examples'. Or here are various examples.

regards,
Delna
Re: email on job start/complete [message #582860 is a reply to message #582843] Tue, 23 April 2013 02:56 Go to previous message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A trigger does not apply to a procedure only to DML (and DDL).
Please have a look at Database SQL Reference for the different kind of triggers.

Regards
Michel
Previous Topic: how to populate a distinct column in a table
Next Topic: How to get the total number of occurrences based on the value of a column.
Goto Forum:
  


Current Time: Wed Jul 30 18:56:34 CDT 2014

Total time taken to generate the page: 0.14036 seconds