Re: HOW TO KILL ALL DBMS.JOB?!!!

Not sure what you mean by killing all jobs, but if you just want them to stop being executed, you can simply stop all SNP processes by doing

ALTER SYSTEM SET job_queue_processes=0

(you gotta have ALTER SYSTEM privilege to do that). If any job is currently running, the SNP running it will not be stopped until the job is complete. Note that stopping all SNPs will also stop automatic snapshot refresh.

If you want to delete all jobs but keep the job queue processes running, you need to iteratively call dbms_job.remove for each job (and you need to call it as the job owner). For example,

for x in (select job from user_jobs) loop  dbms_job.remove(x.job);
end loop;

You can not remove a job you don't own.

hth.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Mariusz" <mgerhant_at_wp.pl> wrote in message news:a14e8m$ba3$1_at_news.tpi.pl...


> Hi,

> Id' like to kill all job on my server!

> How can I do that?!!!

> Thanks

> Mariusz

> 

> 

> 

>