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?
On Sat, 14 Jun 2003 23:50:52 GMT, "Ryan" <rgaffuri_at_cox.net> wrote:
>
>"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.
>
desc dbms_ijob
returns nothing, is there really such a package? Received on Sun Jun 15 2003 - 02:52:21 CDT