Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do you kill a job of a user scheduled job?

Re: How do you kill a job of a user scheduled job?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 14 Jun 2003 21:20:45 +0100
Message-ID: <3eeb94ee$1_2@mk-nntp-1.news.uk.worldonline.com>


"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:7p1mevg7cfb2i1peu7rsjr8gi26pvro5dh_at_4ax.com...
> On Sat, 14 Jun 2003 10:37:06 GMT, Peter <peter_at_nomorenewsspammin.ca>
> wrote:
>
> >How do you kill a job of a user scheduled job that is listed in
> >users_job table?
> >
> >Thanks.
>
>
> dbms_job.broken(<job_number>)
>
>
> And you have to be connected as the owner of the job
>

Just to reinforce Sybrand's last sentence: Please bear in mind that only the job owner can do *anything* with jobs.

Regards,
Paul Received on Sat Jun 14 2003 - 15:20:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US