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

dbms_job.remove

select 'exec dbms_job.remove('||job||');' from user_jobs;

then copy and paste the results.

however, you need to set it to broken before you remove it or it will still run.

so do the above with dbms_job.broken first. btw, if you want to cancel a job and make sure its rescheduled. the easiest way to do it is, set to broken, remove, reschedule. I usually use a procedure for this, so I just pass the job number.
"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:7f9oevcj26hfmol8v8oc1qj439llu7h2f3_at_4ax.com...
> On Sat, 14 Jun 2003 13:30:52 +0200, Sybrand Bakker
> <gooiditweg_at_sybrandb.demon.nl> wrote:
>
> >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
> >
>
> I tried that before. the job is stopped.
> But
> select job, what from user_jobs;
> still returns a list of jobs. How do I remove all the jobs from the
> user_jobs table?
>
> Thanks
>
> >
> >Sybrand Bakker, Senior Oracle DBA
> >
> >To reply remove -verwijderdit from my e-mail address
>
Received on Sun Jun 15 2003 - 08:38:30 CDT