Toad World® Forums

bug in dbms_job alter script

If you alter a dbms_job on a RAC database, part of the script is missing.

You end up with someting like this…

SYS.DBMS_IJOB.INTERVAL

    (job => 4

    ,interval   => 'SYSDATE+5/1440 ');

    ,instance  => 0

    ,force     => TRUE);

When it should be something like this…

SYS.DBMS_IJOB.INTERVAL

    (job => 4

    ,interval   => 'SYSDATE+5/1440 ');

SYS.DBMS_IJOB.INSTANCE

    (job => 4

    ,instance  => 0

    ,force     => TRUE);

Seen in 12.7.0.121 and 12.5.0.99, probably everything in between too, but not confirmed.

Thanks. I see that and will fix. As a workaround, log in as the owner of the job so that it uses dbms_job instead of dbms_ijob, and the script will be correct.