{"id":161,"date":"2012-03-02T01:53:10","date_gmt":"2012-03-02T01:53:10","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=161"},"modified":"2013-08-29T05:17:12","modified_gmt":"2013-08-29T05:17:12","slug":"job-details","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=161","title":{"rendered":"Job details (<=9i)"},"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 \/>\nSET LINESIZE 230<br \/>\nSET PAGESIZE 9999<br \/>\nSET VERIFY   OFF<\/p>\n<p>COLUMN job        FORMAT 999   HEADING 'Job ID'<br \/>\nCOLUMN username   FORMAT a15   HEADING 'User'<br \/>\nCOLUMN what       FORMAT a30   HEADING 'What'<br \/>\nCOLUMN next_date  FORMAT a22   HEADING 'Next Run Date'<br \/>\nCOLUMN interval   FORMAT a30   HEADING 'Interval'<br \/>\nCOLUMN last_date  FORMAT a22   HEADING 'Last Run Date'<br \/>\nCOLUMN failures                HEADING 'Failures'<br \/>\nCOLUMN broken     FORMAT a7    HEADING 'Broken?'<\/p>\n<p>SELECT<br \/>\n    job<br \/>\n  , log_user username<br \/>\n  , what<br \/>\n  , TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') next_date<br \/>\n  , interval<br \/>\n  , TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_date<br \/>\n  , failures<br \/>\n  , broken<br \/>\nFROM<br \/>\n    dba_jobs<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<pre class=\"qcode\">\r\nSET LINESIZE 230\r\nSET PAGESIZE 9999\r\nSET VERIFY   OFF\r\n\r\nCOLUMN job        FORMAT 999   HEADING 'Job ID'\r\nCOLUMN username   FORMAT a15   HEADING 'User'\r\nCOLUMN what       FORMAT a30   HEADING 'What'\r\nCOLUMN next_date  FORMAT a22   HEADING 'Next Run Date'\r\nCOLUMN interval   FORMAT a30   HEADING 'Interval'\r\nCOLUMN last_date  FORMAT a22   HEADING 'Last Run Date'\r\nCOLUMN failures                HEADING 'Failures'\r\nCOLUMN broken     FORMAT a7    HEADING 'Broken?'\r\n\r\nSELECT\r\n    job\r\n  , log_user username\r\n  , what\r\n  , TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') next_date\r\n  , interval\r\n  , TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_date\r\n  , failures\r\n  , broken\r\nFROM\r\n    dba_jobs\r\n\/\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SET LINESIZE 230 SET PAGESIZE 9999 SET VERIFY OFF COLUMN job FORMAT 999 HEADING &#8216;Job ID&#8217; COLUMN username FORMAT a15 HEADING &#8216;User&#8217; COLUMN what FORMAT a30 HEADING &#8216;What&#8217; COLUMN next_date FORMAT a22 HEADING &#8216;Next Run Date&#8217; COLUMN interval FORMAT a30 HEADING &#8216;Interval&#8217; COLUMN last_date FORMAT a22 HEADING &#8216;Last Run Date&#8217; COLUMN failures HEADING &#8216;Failures&#8217; COLUMN [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":74,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-161","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-2B","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/161","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=161"}],"version-history":[{"count":4,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/161\/revisions"}],"predecessor-version":[{"id":448,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/161\/revisions\/448"}],"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=161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}