{"id":17927,"date":"2019-02-22T13:54:04","date_gmt":"2019-02-22T16:54:04","guid":{"rendered":"https:\/\/orabr.com\/?p=17927"},"modified":"2019-02-22T13:54:12","modified_gmt":"2019-02-22T16:54:12","slug":"oracle-dbms_scheduler-create_jo-execucao-em-background-via-banco","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=17927","title":{"rendered":"ORACLE DBMS_SCHEDULER.CREATE_JO – EXECU\u00c7\u00c3O EM BACKGROUND VIA BANCO"},"content":{"rendered":"\n

BEGIN\n  DBMS_SCHEDULER.CREATE_JOB (JOB_NAME      =>  'NOME_DO_MEU_JOB' \n                            ,JOB_TYPE      =>  'PLSQL_BLOCK'\n                            ,JOB_ACTION    =>  'BEGIN \n                                                  nome_da_procedure; \n                                                END;'  \n                            ,START_DATE    =>  SYSDATE\n                            ,ENABLED       =>  TRUE\n                            ,AUTO_DROP     =>  TRUE\n                            ,COMMENTS      =>  'DESCRICAO NOME_DO_MEU_JOB');\n\nEND;               \n\n--CONSULTAR JOB\nSELECT * \n  FROM dba_scheduler_jobs \n  WHERE job_name = 'NOME_DO_MEU_JOB';     --EM EXECUCAO\nSELECT * \n  FROM dba_scheduler_job_log \n WHERE job_name like 'NOME_DO_MEU_JOB';  --FINALIZADO COM ERRO OU NORMAL\n<\/code><\/pre>\n<\/HTML><\/HTML>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,124,122,138],"tags":[],"class_list":["post-17927","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-database","category-dba-atg-oracle","category-sql"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17927"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17927\/revisions"}],"predecessor-version":[{"id":17928,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/17927\/revisions\/17928"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}