Jim Kennedy wrote:
> "HK" <harikishan.b_at_gmail.com> wrote in message
> news:1154012222.258354.121930_at_m79g2000cwm.googlegroups.com...
>> Hi I need to send an updated select statement by email from PL/SQL.
>> This should be automated process. I am able to send email from PL/SQL
>> but not sure how to schedule this as automated process. also can any
>> one help me how to send attachments using pl/sql mails.
>>
>> Thanks
>> HK
>>
> Use the dbms_jobs package.
> Jim
If in 9i the DBMS_SCHEDULER package if in 10g.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 28 2006 - 16:57:04 CDT
