Yea, I've got the 'running the unix shell script' part down...did you see
the mails someone sent re: utl_smtp??
"hit any user to continue"
__________________
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com
-----Original Message-----
Sent: 03 September 2001 17:35
To: Multiple recipients of list ORACLE-L
well, we don't send it out of pl/sql directly, we run shell scripts that
run the sql, then use shell to check the results and if it meets the "send a
message" criteria, we use mail or mailx to send it.
you can use pipes to call unix shell programs though
>From: "Thomas, Kevin" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Duhvelopers and DB-ehs?
>Date: Mon, 03 Sep 2001 01:40:35 -0800
>
>OOooh, that's something I want to be able to do is to send email to us
>in case of problems...I can send email from OraForms using Outlook but
>I've not got round to checking out how I send email from a Unix box
>via pl/sql or the likes....any suggestions?
>
>K.
>
>"hit any user to continue"
>__________________
>
>Kevin Thomas
>Technical Analyst
>Deregulation Services
>Calanais Ltd.
>(2nd Floor East - Weirs Building)
>Tel: 0141 568 2377
>Fax: 0141 568 2366
>http://www.calanais.com
>
>
>-----Original Message-----
>Sent: 31 August 2001 17:38
>To: Multiple recipients of list ORACLE-L
>
>
>we have homegrown shell scripts -- page us, email us, send daily status of
>the world reports... works!
>
>
>
> >From: "Thomas, Kevin" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Duhvelopers and DB-ehs?
> >Date: Fri, 31 Aug 2001 05:47:12 -0800
> >
> >Database monitoring tools....thrrp! We wrote our own using Java and lots
>of
> >SQL are shell scripts...patchy but it works ;-)
> >
> >
> >__________________
> >
> >Kevin Thomas
> >Technical Analyst
> >Deregulation Services
> >Calanais Ltd.
> >(2nd Floor East - Weirs Building)
> >Tel: 0141 568 2377
> >Fax: 0141 568 2366
> >http://www.calanais.com
> >
> >
> >-----Original Message-----
> >Sent: 31 August 2001 14:17
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I've got 11 databases (and just found out I'll probably have a new one, a
> >semi, sort of, kind of data warehouse -- I need those books!)
> >
> >and there is me, my junior DBA who is not so junior anymore, and one
> >consultant.
> >
> >And my CTO thinks that the DBAs are really just extra programming
> >resources.
> >
> >So half the time we are doing non-DBA work.
> >
> >Oh yeah, and we don't have any of those high-falutin' database monitoring
> >tools either :)
> >
> >
> > >From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: RE: Duhvelopers and DB-ehs?
> > >Date: Fri, 31 Aug 2001 02:55:26 -0800
> > >
> > >Bloody Hell, we have half that amount of systems yet only two DBAs.
>What
> >on
> > >earth do they do with the rest of their time.
> > >
> > >
> > >-----Original Message-----
> > >Sent: 31 August 2001 09:40
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >LOL...with 31 systems to support 24/7/365 if you threw a stone in any
> > >direction you would hit a DBA. At the last count I believe we had
>12...!!
> > >
> > >
> > >__________________
> > >
> > >Kevin Thomas
> > >Technical Analyst
> > >Deregulation Services
> > >Calanais Ltd.
> > >(2nd Floor East - Weirs Building)
> > >Tel: 0141 568 2377
> > >Fax: 0141 568 2366
> > >http://www.calanais.com
> > >
> > >
> > >-----Original Message-----
> > >Sent: 30 August 2001 17:22
> > >To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >Sounds like your company is looking for a new DBA? :-))))
> > >
> > >Jan Pruner
> > >
> > >Dne ?t 30. srpen 2001 17:26 jste napsal(a):
> > > > I have to say I resent being called a duhveloper, granted the
>majority
> > > > couldn't tune a banjo let alone tune a piece of SQL, but as a techie
> > >(and
> > > > we all are), I find this list invaluable for getting advice on a
>wide
> > >range
> > > > of topics, not just keeping a DB up and running or tuned...I don't
> >call
> > >you
> > > > guys names, and let's face it you DB-ehs? couldn't write a decent
> > > > application if your lives depended on it...
> > > >
> > > > (blue touch-paper lit, retire a distance, do not re-approach once
>lit,
> > >and
> > > > wait for fireworks)
> > > >
> > > >
> > > > "hit any user to continue"
> > > > __________________
> > > >
> > > > Kevin Thomas
> > > > Technical Analyst
> > > > Deregulation Services
> > > > Calanais Ltd.
> > > > (2nd Floor East - Weirs Building)
> > > > Tel: 0141 568 2377
> > > > Fax: 0141 568 2366
> > > > http://www.calanais.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > Sent: 30 August 2001 15:46
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >
> > > > no, those posts keep us "underworked" DBAs from killing the
> >duhvelopers
> > >who
> > > > make us do the same thing over and over and over and who never
>listen
> > >when
> > > > we tell them the correct way to design the tables.
> > > >
> > > > :)
> > > >
> > > > From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
> > > >
> > > > >Reply-To: [EMAIL PROTECTED]
> > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > > >Subject: RE: !! Keeping the list alive
> > > > >Date: Thu, 30 Aug 2001 04:00:52 -0800
> > > > >
> > > > >Just look at the number of OT postings in the last couple of
> >months...
> > > > >
> > > > >: )
> > > > >
> > > > >Patrice Boivin
> > > > >Systems Analyst (Oracle Certified DBA)
> > > > >
> > > > >Systems Admin & Operations | Admin. et Exploit. des systèmes
> > > > >Technology Services | Services technologiques
> > > > >Informatics Branch | Direction de l'informatique
> > > > >Maritimes Region, DFO | Région des Maritimes, MPO
> > > > >
> > > > >E-Mail: [EMAIL PROTECTED]
><mailto:[EMAIL PROTECTED]>
> > > > >
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > > > > Sent: Wednesday, August 29, 2001 7:58 PM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > > Subject: RE: !! Keeping the list alive
> > > > >
> > > > > You're surprised at those willing to pay?
> > > > >
> > > > > You have to realize that most DBAs are over-payed and
under-worked
> > > > >....
> > > > > <<ducking>>
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Wednesday, August 29, 2001 1:43 PM
> > > > > > To: Multiple recipients of list ORACLE-L
> > > > > > Subject: !! Keeping the list alive
> > > > > >
> > > > > >
> > > > > >
> > > > > > This list is apparently a more valuable resource to many
of you
> > > > >
> > > > >than I
> > > > >
> > > > > > realized.
> > > > > >
> > > > > > I'm literally bowled over by the generosity. I've
received
> > > > > > so many emails
> > > > > > about
> > > > > > this that I really can't personally reply to them all
right now.
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > --
> > > > > Author:
> > > > > INET: [EMAIL PROTECTED]
> > > > >
> > > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
>538-5051
> > > > > San Diego, California -- Public Internet access /
Mailing
> > > > >Lists
> > > >
> > --------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an E-Mail
message
> > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
and
>in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed from).
You
>may
> > > > > also send the HELP command for other information (like
>subscribing).
> > > > >--
> > > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > >--
> > > > >Author: Boivin, Patrice J
> > > > > INET: [EMAIL PROTECTED]
> > > > >
> > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > >San Diego, California -- Public Internet access / Mailing
> >Lists
> > > >
> >--------------------------------------------------------------------
> > > > >To REMOVE yourself from this mailing list, send an E-Mail message
> > > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > > >the message BODY, include a line containing: UNSUB ORACLE-L
> > > > >(or the name of mailing list you want to be removed from). You may
> > > > >also send the HELP command for other information (like
>subscribing).
> > > >
> > > > _________________________________________________________________
> > > > Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Jan Pruner
> > > INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Thomas, Kevin
> > > INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> > >
> > >
> > >The information contained in this communication is
> > >confidential, is intended only for the use of the recipient
> > >named above, and may be legally privileged. If the reader
> > >of this message is not the intended recipient, you are
> > >hereby notified that any dissemination, distribution or
> > >copying of this communication is strictly prohibited.
> > >If you have received this communication in error, please
> > >re-send this communication to the sender and delete the
> > >original message or any copy of it from your computer
> > >system.
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Robertson Lee - lerobe
> > > INET: [EMAIL PROTECTED]
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at
>http://explorer.msn.com/intl.asp
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> > INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Thomas, Kevin
> > INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Thomas, Kevin
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas, Kevin
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
