stopping jobs scheduled on the database

I have a replicated environment and I need to stop the jobs from running on the target database what command would I issue.
These jobs are owned by other users.
Also what query would get me the job queues so that I could issue a "exec dbms_job.remove();

Thanks in advance
Chintz

Thank You I figured it out. THe statementis
exec dbms_job.remove(job_#);
But has to be run as the job owner.

-Chintz

Quote:

---

Originally posted by Chintz
Thank You I figured it out. THe statementis
exec dbms_job.remove(job_#);
But has to be run as the job owner.

---

There is also an undocumented package SYS.DBMS_IJOB that allows you (if you are authorised to use this package) to manage jobs that are not owned by you.

Quote:

---

Originally posted by Chintz
Thank You I figured it out. THe statementis
exec dbms_job.remove(job_#);
But has to be run as the job owner.

-Chintz

---

How about commiting the work afterwards :-)