{"id":1983,"date":"2021-01-18T13:18:25","date_gmt":"2021-01-18T13:18:25","guid":{"rendered":"https:\/\/swiv.com.br\/solved-issue-ora-23421-job-number-205759-is-not-a-job-in-the-job-queue\/"},"modified":"2026-05-27T20:02:53","modified_gmt":"2026-05-27T19:02:53","slug":"solved-issue-ora-23421-job-number-205759-is-not-a-job-in-the-job-queue","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/01\/18\/solved-issue-ora-23421-job-number-205759-is-not-a-job-in-the-job-queue\/","title":{"rendered":"[Solved] Issue: ORA-23421: job number 205759 is not a job in the job queue"},"content":{"rendered":"\n

Percebi que eu tinha alguns Jobs em BROKEN, e precisava normaliz\u00e1-los:<\/p>\n\n\n

\nSQL> SELECT JOB,SCHEMA_USER,LAST_DATE,NEXT_DATE,BROKEN FROM DBA_JOBS WHERE LOG_USER='TESTE12' AND BROKEN='Y';\n \n       JOB SCHEMA_USER                    LAST_DAT NEXT_DAT B\n---------- ------------------------------ -------- -------- -\n    205758 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205759 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205778 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205739 TESTE12                        09\/11\/20 01\/01\/00 Y\n    205740 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205780 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205838 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205886 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205887 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205883 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205884 TESTE12                        17\/01\/20 01\/01\/00 Y\n    205885 TESTE12                        17\/01\/20 01\/01\/00 Y\n \n12 linhas selecionadas.\n<\/pre><\/div>\n\n\n
\u00c9 poss\u00edvel tirar o status broken do Job usando o comando abaixo:<\/p>\n\n\n
\nEXEC DBMS_JOB.BROKEN(205758,FALSE);\nEXEC DBMS_JOB.BROKEN(205759,FALSE);\nEXEC DBMS_JOB.BROKEN(205778,FALSE);\nEXEC DBMS_JOB.BROKEN(205739,FALSE);\nEXEC DBMS_JOB.BROKEN(205740,FALSE);\nEXEC DBMS_JOB.BROKEN(205780,FALSE);\nEXEC DBMS_JOB.BROKEN(205838,FALSE);\nEXEC DBMS_JOB.BROKEN(205886,FALSE);\nEXEC DBMS_JOB.BROKEN(205887,FALSE);\nEXEC DBMS_JOB.BROKEN(205883,FALSE);\nEXEC DBMS_JOB.BROKEN(205884,FALSE);\nEXEC DBMS_JOB.BROKEN(205885,FALSE);\n<\/pre><\/div>\n\n\n
Por\u00e9m, ao tentar rodar o primeiro deles, me deparei com este erro (estava logado com um usu\u00e1rio DBA):<\/p>\n\n\n
\nSQL> EXEC DBMS_JOB.BROKEN(205758,TRUE);\nBEGIN DBMS_JOB.BROKEN(205758,TRUE); END;\n \n*\nERRO na linha 1:\nORA-23421: job number 205758 is not a job in the job queue\nORA-06512: at "SYS.DBMS_SYS_ERROR", line 86\nORA-06512: at "SYS.DBMS_IJOB", line 592\nORA-06512: at "SYS.DBMS_JOB", line 252\nORA-06512: at line 1\n<\/pre><\/div>\n\n\n
Logo, percebi que mesmo conectado com um usu\u00e1rio DBA, precisaria me conectar com o owner dono do Job (e n\u00e3o adiantar tentar fazer o ALTER SESSION SET CURRENT_SCHEMA). Por\u00e9m, eu n\u00e3o tinha a senha deste owner, e precisei salvar o seu HASH, alterar momentaneamente a sua senha, conforme abaixo:<\/p>\n\n\n
\nSQL> SELECT NAME,PASSWORD FROM SYS.USER$ WHERE NAME='TESTE12';\n \nNAME                           PASSWORD\n------------------------------ ------------------------------\nTESTE12                        D604551CB7C030FF\nSQL> ALTER USER TESTE12 IDENTIFIED BY TESTE12 ACCOUNT UNLOCK;\n \nUsu\u00dfrio alterado.\n<\/pre><\/div>\n\n\n
Logando com o owner e executando os scripts: <\/p>\n\n\n
\nC:\\Users\\bruno>sqlplus TESTE12\/TESTE12@BANCO\n \nSQL*Plus: Release 12.2.0.1.0 Production on Seg Jan 18 09:46:27 2021\n \nCopyright (c) 1982, 2016, Oracle.  All rights reserved.\n \nHor\u00dfrio do \u00b7ltimo log-in bem-sucedido: Qui Ago 13 2020 17:13:14 -03:00\n \nConectado a:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nAdvanced Analytics and Real Application Testing options\n \nSQL> EXEC DBMS_JOB.BROKEN(205758,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205759,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205778,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205739,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205740,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205780,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205838,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205886,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205887,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205883,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205884,FALSE);\n \nPL\/SQL procedure successfully completed.\n \nSQL> EXEC DBMS_JOB.BROKEN(205885,FALSE);\n \nPL\/SQL procedure successfully completed.\n<\/pre><\/div>\n\n\n
Voltando a senha antiga do owner:<\/p>\n\n\n
\nSQL> ALTER USER TESTE12 IDENTIFIED BY VALUES 'D604551CB7C030FF' ACCOUNT UNLOCK;\n \nUsu\u00dfrio alterado.\n<\/pre><\/div>\n\n\n
Ou, se voc\u00ea puder, \u00e9 poss\u00edvel rodar o Job manualmente, conforme exemplo abaixo:<\/p>\n\n\n
\nEXEC DBMS_JOB.RUN(205758);\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Percebi que eu tinha alguns Jobs em BROKEN, e precisava normaliz\u00e1-los: \u00c9 poss\u00edvel tirar o status broken do Job usando o comando abaixo: Por\u00e9m, ao tentar rodar o primeiro deles, me deparei com este erro (estava logado com um usu\u00e1rio DBA): Logo, percebi que mesmo conectado com um usu\u00e1rio DBA, precisaria me conectar com o […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[19],"class_list":["post-1983","post","type-post","status-publish","format-standard","hentry","category-administration","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1983"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1983\/revisions"}],"predecessor-version":[{"id":9281,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1983\/revisions\/9281"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}