dbms_job problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms_job problem

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    SQL> select * from dba_jobs;

    JOB LOG_USER PRIV_USER
    --------- ------------------------------ -----------
    10 DEMO_320 DEMO_320

    INSTANCE
    --------
    0

    How can i remove this, if i try the following:

    SQL> execute dbms_job.remove(10);
    BEGIN dbms_job.remove(10); END;

    *
    ERROR at line 1:
    ORA-23421: job number 10 is not a job in the job queue
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
    ORA-06512: at "SYS.DBMS_IJOB", line 525
    ORA-06512: at "SYS.DBMS_JOB", line 166
    ORA-06512: at line 1


    please help

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    do you try to remove this job while being connected as the owner of it ??? if not this is a normal behaviour ...

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    thanks, i thought i had tried to remove with owner, but it seems i didnt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width