I see at the Controll Center (OWB 10.2.0.1), at the Excecution Tab that every night a number of jobs are executed that their owner is lets say BLA_REP.
I want to disable these jobs but I cant find them anywhere!! They are not visible when I run any of the following
'select * from DBA_JOBS_RUNNING;'
'select * from DBA_JOBS;'
'select * from USER_JOBS;'
'select * from DBA_SCHEDULER_JOBS;'
'select * from USER_SCHEDULER_JOBS;'
'select * from ALL_SCHEDULER_JOBS;'
'select * from DBA_SCHEDULER_JOB_CLASSES;'
'select * from ALL_SCHEDULER_JOB_CLASSES;'
'select * from DBA_SCHEDULER_RUNNING_JOBS;'
'select * from ALL_SCHEDULER_RUNNING_JOBS;'
'select * from USER_SCHEDULER_RUNNING_JOBS;'
Should I check somewhere in OWB? Wherever I could search I think I allready have, and still no luck. But these jobs DO run everynight..
Two years later I came back (for something else) but I have an answer to that - the jobs where deleted but propably "hung" in the queue table (WB_RT_NOTIFY_QUEUE_TAB) and the Control Panel "thought" that they were still running... Very strange.
We had to truncate the queue table for other reason and I realized the answer of that old mystery.