Results 1 to 2 of 2

Thread: update dbms job

  1. #1
    Join Date
    Jun 2005
    Posts
    53

    Unanswered: update dbms job

    Hi all,

    I am trying to change broken job with following code:

    BEGIN
    DBMS_JOB.BROKEN(JOB => 21, BROKEN => FALSE, NEXT_DATE => TO_DATE('08-10-03 23:00', 'YY-MM-DD HH24:MI'));
    END;


    but getting this error:

    ORA-23421: job number 21 is not a job in the job queue
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
    ORA-06512: at "SYS.DBMS_IJOB", line 529
    ORA-06512: at "SYS.DBMS_JOB", line 245
    ORA-06512: at line 2

    but on the select from dba_jobs shows job 21 and 22!!

    Please help!!

    thanks
    Pat

  2. #2
    Join Date
    Jun 2005
    Posts
    53
    solved it.. was loged in as diffrenet user!! sorry for troubles that i might have cause!!

Posting Permissions

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