{"id":858,"date":"2012-05-09T20:24:46","date_gmt":"2012-05-09T18:24:46","guid":{"rendered":"https:\/\/oracle-in-zen.de\/?p=858"},"modified":"2021-05-31T14:16:29","modified_gmt":"2021-05-31T13:16:29","slug":"dbconsole-job-hangt-in-status-stop-pending-auf-beenden-wird-gewartet","status":"publish","type":"post","link":"https:\/\/oracle-in-zen.de\/?p=858","title":{"rendered":"DBconsole Job h\u00e4ngt in Status &#8222;stop pending&#8220; &#8211; &#8222;auf beenden wird gewartet&#8220;"},"content":{"rendered":"<p>Was kann getan werden wenn in der Job- \u00dcbersicht der DBconsole eine &#8217;stop pending&#8216; Meldung erscheint, diese aber nie &#8222;fertig&#8220; wird?<br \/>\n<!--more--><br \/>\nEin Job kann nicht gel\u00f6scht werden, da er noch mit &#8218;wird ausgef\u00fchrt&#8216; angezeigt und behandelt wird. Obwohl der Job definitiv fertig und erfolgreich beendet wurde.<\/p>\n<p>Eine M\u00f6glichkeit ist den Statuswert des Jobs manuell zu \u00e4ndern.<\/p>\n<p>Zuerst muss der Job jedoch genauer identifiziert werden.<\/p>\n<pre>select job_id, job_name, job_owner from mgmt_job\r\nwhere job_name like &#039;ORCLUSER.MEINJOB&#039;;\r\n\r\nJOB_ID\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 JOB_NAME\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 JOB_OWNER\r\n--------------------------------- ----------------- ---------\r\nV5C443D05F54478B990B68CE6A526F76  ORCLUSER.MEINJOB  ORCLUSER<\/pre>\n<p>Nachdem nun die JOB_ID bekannt ist, kann die EXECUTION_ID besser gesucht werden:<\/p>\n<pre>select execution_id, status from mgmt_job_exec_summary\r\nwhere job_id=&#039;V5C443D05F54478B990B68CE6A526F76&#039;;\r\n\r\nEXECUTION_ID\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0STATUS\r\n-------------------------------- -------\r\nBC1B0E66C1937435E040460A29147ED8 5\r\nBBB679617ADE0507E040460A291452DC 5\r\nBBCA970D7AA48C18E040460A291413FE 5\r\nV5FG443D05F54478B990B68CE6A526F7 5\r\nV5C443D05F54478B990B68CE6A526F76 12\r\nBBDEB51156E447A1E040460A29145372 5\r\nBC06F0C99BACD91EE040460A2914555D 5<\/pre>\n<p>Nun kann der STATUS des Jobs gesetzt und von &#8222;stop pending&#8220; zu &#8222;successful&#8220; ge\u00e4ndert werden.<\/p>\n<pre>update mgmt_job_exec_summary SET status=5,\u00a0end_time=(sysdate-1)\r\nwhere job_id=&#039;V5C443D05F54478B990B68CE6A526F76&#039;\u00a0and status=12;\r\n\r\n1 row updated.\r\n\r\ncommit;\r\n\r\nCommit complete.\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Was kann getan werden wenn in der Job- \u00dcbersicht der DBconsole eine &#8217;stop pending&#8216; Meldung erscheint, diese aber nie &#8222;fertig&#8220; wird?<\/p>\n","protected":false},"author":1,"featured_media":1081,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"zakra_page_container_layout":"customizer","zakra_page_sidebar_layout":"customizer","zakra_remove_content_margin":false,"zakra_sidebar":"customizer","zakra_transparent_header":"customizer","zakra_logo":0,"zakra_main_header_style":"default","zakra_menu_item_color":"","zakra_menu_item_hover_color":"","zakra_menu_item_active_color":"","zakra_menu_active_style":"","zakra_page_header":true,"footnotes":""},"categories":[24],"tags":[20,47,48,18],"class_list":["post-858","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-db-console","tag-dbconsole","tag-enterprise-manager","tag-job","tag-script"],"_links":{"self":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=858"}],"version-history":[{"count":21,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/858\/revisions"}],"predecessor-version":[{"id":1315,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/858\/revisions\/1315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/media\/1081"}],"wp:attachment":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}