1 Reply Latest reply on Oct 20, 2010 11:20 AM by Ethymia

    "Ghost" jobs at Control Center

      Very strange situation once more...

      I see at the Controll Center (OWB, 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..

      Any suggestions wellcome!
        • 1. Re: "Ghost" jobs at Control Center
          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.