Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you kill a job of a user scheduled job?
"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