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: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 14 Jun 2003 13:30:52 +0200
Message-ID: <7p1mevg7cfb2i1peu7rsjr8gi26pvro5dh@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

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jun 14 2003 - 06:30:52 CDT

Original text of this message

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