Re: RE: Mailing frm Oracle

Yes, and dbms_ijob will allow you to manage jobs that are not owned by you. I had to do the same thing as Regs... those jobs can be very persistent little guys. Break them first, then kill the session ID running the job. This will stop them.

John Dailey
Consultant
Concept Solutions, LLC

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Sunday, February 25, 2001 2:10 AM

> I also had same problem before, but dbms_job.broken procedure takes care
of
> it. I first broke the job and then removed it.
>
> It works.
>
> Regs,
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, February 23, 2001 5:11 AM
>
>
> > one caution:
> >
> > If you're using Oracle 8.1.x on NT (NT4 - W2K)
> > you will have some serious issues with killing dba_jobs.
> > okay - its very easy to kill a dbms_job.
> > shutdown abort takes care of it - no problem.
> > I had a dbms_job emptying a mail queue that opened 3976 connections to a
> > Sendmail server last night - it stopped at port 4999 (testing code). The
> > mail server didn't even blink.
> >
> > I could not kill a dbms_job - as it deferred the kill session.
> > 7.3 use to have a parameter that allowed you to not keep the connection
> > alive.
> > That parameter isn't available in 8.1.6.
> >
> > So once again, less ways to get at the OS - less ways to maintain
> processes.
> > If you actually have users that don't want to have their instance
> shutdown,
> > better test that code very well ...
> >
> > Paul
> >
> >
> > -------- Original Message --------
> > Date: Thu, 22 Feb 2001 14:40:27 -0800
> > Reply-To: ORACLE-L_at_fatcity.com
> > Organization: Fat City Network Services, San Diego, California
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >
> > On 8.1.6+ you can use UTL_SMTP.
> > Vadim Gorbounov
> > Oracle DBA
> >
> > -----Original Message-----
> > Sent: Thursday, February 22, 2001 3:11 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Everybody,
> >
> > I wanted to forward a mail to a particular Id thru an Oracle Procedure ,
> > can anybody tell me whether I can do that thru an Oralce Procedure
> > if so pls inform how to do the same.
> >
> > I dont want to mail to a Unix Login id , I want to mail to a mail server
> >
> > For e-g test_at_hotmail.com
> >
> >
> > Thanks In Advance,
> >
> > Shankar Swamy.
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shankar Shanmugaswamy
> > INET: sshankar_at_lason.com
> >
> > 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: ListGuru_at_fatcity.com (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: Vadim Gorbounov
> > INET: vgorbounov_at_simplyengineering.com
> >
> > 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: ListGuru_at_fatcity.com (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: Paul Drake
> > INET: drake_at_psscorp.com
> >
> > 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: ListGuru_at_fatcity.com (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).
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjali R
> INET: anjali_r_1999_at_yahoo.co.uk
>
> 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: ListGuru_at_fatcity.com (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: John Dailey
  INET: john.dailey_at_concept-solutions.com

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: ListGuru_at_fatcity.com (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).