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
-
John,
Thanks for the info.
Paul
John Dailey wrote:
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
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" [EMAIL PROTECTED]
Sent: Friday, February 23, 2001 5:11 AM
one caution:
If
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
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