{"id":289,"date":"2011-04-16T18:18:25","date_gmt":"2011-04-17T01:18:25","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=289"},"modified":"2011-04-16T18:18:25","modified_gmt":"2011-04-17T01:18:25","slug":"crear-job-en-oracle","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2011\/04\/16\/crear-job-en-oracle\/","title":{"rendered":"Crear JOB en Oracle"},"content":{"rendered":"<p>Este c\u00f3digo crea un JOB en Oracle que se ejecuta cada  1 hora<\/p>\n<pre class=\"brush: sql\">\r\nBEGIN\r\nDBMS_JOB.isubmit (\r\njob => 99,\r\nwhat => 'procedimiento(''soy un parametro'');',\r\nnext_date => SYSDATE,\r\ninterval => 'SYSDATE + 1\/24 \/* 1 Hour *\/');\r\n\r\nCOMMIT;\r\nEND;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Este c\u00f3digo crea un JOB en Oracle que se ejecuta cada 1 hora BEGIN DBMS_JOB.isubmit ( job => 99, what => &#8216;procedimiento(\u00bbsoy un parametro\u00bb);&#8217;, next_date => SYSDATE, interval => &#8216;SYSDATE + 1\/24 \/* 1 Hour *\/&#8217;); COMMIT; END;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4,9],"tags":[],"class_list":["post-289","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-desarrollo","category-oracle"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/289"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":1,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/289\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}