Home » RDBMS Server » Server Administration » job showing on dba_job even after being removed
job showing on dba_job even after being removed [message #61653] Thu, 13 May 2004 11:51 Go to next message
Joan
Messages: 36
Registered: February 2002
Member
I removed several jobs which were submitted but the job_queue_process was set to 0.  did dbms_job.remove(jobno).

Everything run fine and was able to remove all the jobs. However,

when I check dba_jobs. the jobs are still showing up . I tried to remove then again but got errors job does not exist in the job queue.

Has anybody run into this issue? Is this oracle bug. I did not find anything on Metalink

 
Re: job showing on dba_job even after being removed [message #61676 is a reply to message #61653] Sun, 16 May 2004 00:35 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

I'm unable to simulate your problem:

SQL> var jobno number
SQL> exec dbms_job.submit(:jobno, 'begin null; end;');

PL/SQL procedure successfully completed.

SQL> print jobno

     JOBNO
----------
        47

SQL> col what format a50
SQL> select job, what from user_jobs;

       JOB WHAT
---------- --------------------------------------------------
        47 begin null; end;

1 row selected.

SQL> exec dbms_job.remove(&jobno);
Enter value for jobno: 47

PL/SQL procedure successfully completed.

SQL> select job, what from user_jobs;

no rows selected


Best regards.

Frank
Previous Topic: oracle tuning.
Next Topic: full index scan
Goto Forum:
  


Current Time: Fri Sep 27 12:25:11 CDT 2024