Skip to Main Content
Forums

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!

Trouble removing disabled jobs from oracle scheduler.

700837Jan 26 2010 — edited Feb 1 2010
Hi,

When I run the query :-

select job_name,job_subname,program_name,enabled,auto_drop,state
from all_SCHEDULER_JOBS
where enabled = 'FALSE'
and state = 'RUNNING'

I get the following results :-

job_name job_subname program_name enabled auto_drop state
DAILY_LOAD STEP30 EQUIP_STATUS_EXECUTE_SCRIPT FALSE TRUE RUNNING
WEEKLY_CHAIN_IMMEDIATE_JOB STEP30_1 MONITOR_EXECUTE_SCRIPT FALSE TRUE RUNNING

There are no entries on the 'ALL_SCHEDULER_RUNNING_CHAINS' table for these jobs.

How can I remove these jobs that are not disabled but have a state of 'running'.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2010
Added on Jan 26 2010
#general-database-discussions
7 comments
1,627 views