Results 1 to 2 of 2

Thread: Job scheduller

  1. #1
    Join Date
    Sep 2003
    Location
    Chiang Mai Thailand
    Posts
    14

    Question Unanswered: Job scheduller

    Help me?
    I try to submit job for update table. But I can not force to execute
    or remove old job. Anyone can tell me why ?
    ----------------------------------------------------------------------------------
    Lokk at my job.
    SQL> SELECT JOB, NEXT_DATE, NEXT_SEC, FAILURES, BROKEN
    2 FROM DBA_JOBS;

    JOB NEXT_DATE NEXT_SEC FAILURES B
    ---------- --------- -------- ---------- -
    81 17-JAN-05 13:18:20 N
    61 18-JAN-04 00:01:00 0 N
    83 17-JAN-05 13:42:27 N



    You can see I have job number 81,61,83 .
    Then I try to execute it .
    -------------------------------------------------------------------------------
    SQL> begin
    2 DBMS_JOB.run(81);
    3 end;
    4 /
    begin
    *
    ERROR at line 1:
    ORA-23421: job number 81 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 258
    ORA-06512: at line 2

    why ??????????????
    And this I try to remove it.

    SQL> begin
    2 dbms_job.remove(81);
    3 end;
    4 /
    begin
    *
    ERROR at line 1:
    ORA-23421: job number 81 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 171
    ORA-06512: at line 2


    Anyone can tell me why ????
    Kindly regards,
    Thana p.
    Chiangmai Thailand
    Yim_cm@hotmail.com

  2. #2
    Join Date
    Sep 2003
    Location
    Chiang Mai Thailand
    Posts
    14

    Talking sorry

    Finally I found!
    I can not remove becasue it reference by user.
    Then if connect SQLPLUS with owner of job it will alter job easily.
    Kindly regards,
    Thana p.
    Chiangmai Thailand
    Yim_cm@hotmail.com

Posting Permissions

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