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

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3eeb94ee$1_2_at_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
>
>
>

if you use an undocumented package called

dbms_ijob.broken and do the same thing you can do it from any user. Its not dangerous. Received on Sat Jun 14 2003 - 18:50:52 CDT