Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stopping an oracle job

CharlovFeb 9 2010 — edited Feb 9 2010
Hello,

I ran the following query on the DB, and it returned a list of jobs
select log_user, job, what, next_date from dba_jobs;

I also ran Select * from dba_running_jobs and it returned a running job.

I tried to terminate the job through:
-DBMS_SCHEDULER.STOP_JOB
- ALTER SYSTEM KILL SESSION
commands,
both did not work. Also the job list generated by dba_jobs is different than the one generated by:
select owner, job_name, next_run_date from dba_scheduler_jobs;

Any idea how to stop the job from running?
Thank you!
This post has been answered by ice_cold_aswin on Feb 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2010
Added on Feb 9 2010
9 comments
3,087 views