Re: DBMS_JOB.SUBMIT

I've faced such problem and not found simple solution. What can I suggest:

dbms_job.broken(<job_id>)
select sid from dba_jobs_running where job=<>job_id> select sid,serial# from v$session where sid=<sid> alter system kill session '<sid,serial#>' dbms_job.remove(<job_id>)

If someone knows simplest solution, it will be great.

<NeedaHoliday> wrote in message
news:2maqatc3aec55rbj4gevcve7cf12497mds_at_4ax.com...
> Quick question, once a job has been submitted to queue, it can be
> removed from queue using REMOVE. But if a job is executing, can it be
> aborted.
>
> I assume I can retrieve the job number and use it to terminate the
> job.
>
> Thanks,
>
> Jim Stewart
>
> james.stewart_at_nospamPWGSC.GC.CA
>
> omit nospam to email
Received on Mon Mar 12 2001 - 14:43:23 CST