Mea culpa, I should have added that this has to work in a 7.3.4 world (HPUX
host) just a few more months....
I have read somewhere that a procedure can execute OS commands, but there
seem to be very few examples. For instance, using the job queue to schedule
exports instead of cron. I may break down and open a TAR....
Tks for the referral.
- Original Message -----
From: "Bricklen Anderson" <bricklen_at_shaw.ca>
Newsgroups: comp.databases.oracle.misc
Sent: Monday, May 13, 2002 10:44 PM
Subject: Re: PLSQL: sending email method?
> Easily done. Try http://asktom.oracle.com and do a search for 8i
> (assuming that you are using 8.1.x) and email. There are lots of
> references there.
>
"Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message
news:3CE0871A.2AA06539_at_shaw.ca...
> Easily done. Try http://asktom.oracle.com and do a search for 8i
> (assuming that you are using 8.1.x) and email. There are lots of
> references there.
>
> hth
>
> Bricklen
>
> David Van Zandt wrote:
> >
> > Here's one not in the books: I'm trying to write PL/SQL to periodically
> > query a user table for its row count, which is normally zero; if the
result
> > is greater than a certain integer, then send an email to an operator to
take
> > corrective action. Basic function and procedure stuff -- except for
that
> > last part; I'm clueless. I'm used to writing a Korn shell to launch
> > SQLPlus, then calling mailx to alert the operator.
> >
> > Oh, and I'm trying to have this run using DBMS_JOB.
> >
> > Can anyone help the poor boy, please?
>
> --
>
>
> -----------------------------
> * http://pipers.hypermart.net *
> -----------------------------
Received on Mon May 13 2002 - 23:55:27 CDT
