{"id":211,"date":"2012-03-02T03:52:35","date_gmt":"2012-03-02T03:52:35","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=211"},"modified":"2012-03-02T03:53:43","modified_gmt":"2012-03-02T03:53:43","slug":"submit-job","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=211","title":{"rendered":"Submit job (<10g)"},"content":{"rendered":"<p><code><br \/>\n<script type=\"text\/javascript\"> \nfunction copy(what) {\n    window.clipboardData.setData('Text',what.value);\n}\nfunction paste(what) {\n    what.value = window.clipboardData.getData('Text');\n}\n<\/script><\/p>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nDECLARE<br \/>\nX NUMBER;<br \/>\nBEGIN<br \/>\nSYS.DBMS_JOB.SUBMIT<br \/>\n( job => X<br \/>\n,what => 'CAPSTONE.STATUS_ALERT;'<br \/>\n,next_date => to_date('19.08.2008 15:40:00','dd\/mm\/yyyy hh24:mi:ss')<br \/>\n,interval => 'SYSDATE+30\/1440 '<br \/>\n,no_parse => TRUE<br \/>\n);<br \/>\nSYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));<br \/>\nEND;<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<pre class=\"qcode\">\r\nDECLARE\r\nX NUMBER;\r\nBEGIN\r\nSYS.DBMS_JOB.SUBMIT\r\n( job => X \r\n,what => 'CAPSTONE.STATUS_ALERT;'\r\n,next_date => to_date('19.08.2008 15:40:00','dd\/mm\/yyyy hh24:mi:ss')\r\n,interval => 'SYSDATE+30\/1440 '\r\n,no_parse => TRUE\r\n);\r\nSYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));\r\nEND;\r\n\/\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => &#8216;CAPSTONE.STATUS_ALERT;&#8217; ,next_date => to_date(&#8216;19.08.2008 15:40:00&#8242;,&#8217;dd\/mm\/yyyy hh24:mi:ss&#8217;) ,interval => &#8216;SYSDATE+30\/1440 &#8216; ,no_parse => TRUE ); SYS.DBMS_OUTPUT.PUT_LINE(&#8216;Job Number is: &#8216; || to_char(x)); END; \/ DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => &#8216;CAPSTONE.STATUS_ALERT;&#8217; ,next_date => to_date(&#8216;19.08.2008 15:40:00&#8242;,&#8217;dd\/mm\/yyyy hh24:mi:ss&#8217;) ,interval => &#8216;SYSDATE+30\/1440 &#8216; ,no_parse [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":74,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-211","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-3p","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=211"}],"version-history":[{"count":2,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/211\/revisions"}],"predecessor-version":[{"id":215,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/211\/revisions\/215"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/74"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}