Stopping an oracle job
CharlovFeb 9 2010 — edited Feb 9 2010Hello,
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!