{"id":339,"date":"2012-07-30T05:43:53","date_gmt":"2012-07-30T05:43:53","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=339"},"modified":"2013-08-29T05:45:07","modified_gmt":"2013-08-29T05:45:07","slug":"11g-jobs","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=339","title":{"rendered":"11g jobs"},"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<h2>\n11g Auto tasks<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 200\r\nSET PAGESIZE 9999\r\nSET VERIFY   OFF\r\n\r\nCOLUMN CLIENT_NAME      \t\tFORMAT a40\tHEADING 'Task name'\r\nCOLUMN STATUS  \t\t\t\t\tFORMAT a9\tHEADING 'Status'\r\nCOLUMN MEAN_JOB_DURATION        FORMAT a30\tHEADING 'Mean job duration'\r\nCOLUMN MAX_DURATION_LAST_7_DAYS FORMAT a30\tHEADING 'Max job duration last 7 days'\r\n\r\nselect CLIENT_NAME, STATUS, MEAN_JOB_DURATION, MAX_DURATION_LAST_7_DAYS from dba_autotask_client\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 200<br \/>\nSET PAGESIZE 9999<br \/>\nSET VERIFY   OFF<\/p>\n<p>COLUMN CLIENT_NAME      \t\tFORMAT a40\tHEADING 'Task name'<br \/>\nCOLUMN STATUS  \t\t\t\t\tFORMAT a9\tHEADING 'Status'<br \/>\nCOLUMN MEAN_JOB_DURATION        FORMAT a30\tHEADING 'Mean job duration'<br \/>\nCOLUMN MAX_DURATION_LAST_7_DAYS FORMAT a30\tHEADING 'Max job duration last 7 days'<\/p>\n<p>select CLIENT_NAME, STATUS, MEAN_JOB_DURATION, MAX_DURATION_LAST_7_DAYS from dba_autotask_client<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<h2>\nJob history<br \/>\n<\/h2>\n<pre class=\"qcode\">\r\nSET LINESIZE 200\r\nSET PAGESIZE 9999\r\nSET VERIFY   OFF\r\n\r\nCOLUMN log_date_char      \tFORMAT a21            HEADING 'Log date'\r\nCOLUMN OWNER  \t\t\t\tFORMAT a15            HEADING 'Owner'\r\nCOLUMN JOB_NAME        \t\tFORMAT a30            HEADING 'Job name'\r\nCOLUMN OPERATION        \tFORMAT a10  \t\t  HEADING 'Operation'\r\nCOLUMN STATUS        \t\tFORMAT a10  \t\t  HEADING 'Status'\r\nCOLUMN ADDITIONAL_INFO \t\tFORMAT a80  \t\t  HEADING 'Additional info'\r\n\r\nselect to_char(LOG_DATE, 'dd\/mm\/yyyy hh24:mi:ss') log_date_char, OWNER, JOB_NAME, OPERATION, STATUS, ADDITIONAL_INFO from dba_scheduler_job_log \r\n\twhere ADDITIONAL_INFO like upper('%&JOB_info%')\r\n\tand log_date > trunc(sysdate) - 30\r\n\torder by log_id\r\n\/\r\n<\/pre>\n<form action=\"\"><textarea name=\"data\" cols=\"50\" rows=\"10\" style=\"display:none;\"><br \/>\nSET LINESIZE 200<br \/>\nSET PAGESIZE 9999<br \/>\nSET VERIFY   OFF<\/p>\n<p>COLUMN log_date_char      \tFORMAT a21            HEADING 'Log date'<br \/>\nCOLUMN OWNER  \t\t\t\tFORMAT a15            HEADING 'Owner'<br \/>\nCOLUMN JOB_NAME        \t\tFORMAT a30            HEADING 'Job name'<br \/>\nCOLUMN OPERATION        \tFORMAT a10  \t\t  HEADING 'Operation'<br \/>\nCOLUMN STATUS        \t\tFORMAT a10  \t\t  HEADING 'Status'<br \/>\nCOLUMN ADDITIONAL_INFO \t\tFORMAT a80  \t\t  HEADING 'Additional info'<\/p>\n<p>select to_char(LOG_DATE, 'dd\/mm\/yyyy hh24:mi:ss') log_date_char, OWNER, JOB_NAME, OPERATION, STATUS, ADDITIONAL_INFO from dba_scheduler_job_log<br \/>\n\twhere ADDITIONAL_INFO like upper('%&JOB_info%')<br \/>\n\tand log_date > trunc(sysdate) - 30<br \/>\n\torder by log_id<br \/>\n\/<br \/>\n<\/textarea><input type=\"button\" value=\"Clipboard\" onclick=\"copy(this.form.data)\"><\/form>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>11g Auto tasks SET LINESIZE 200 SET PAGESIZE 9999 SET VERIFY OFF COLUMN CLIENT_NAME FORMAT a40 HEADING &#8216;Task name&#8217; COLUMN STATUS FORMAT a9 HEADING &#8216;Status&#8217; COLUMN MEAN_JOB_DURATION FORMAT a30 HEADING &#8216;Mean job duration&#8217; COLUMN MAX_DURATION_LAST_7_DAYS FORMAT a30 HEADING &#8216;Max job duration last 7 days&#8217; select CLIENT_NAME, STATUS, MEAN_JOB_DURATION, MAX_DURATION_LAST_7_DAYS from dba_autotask_client \/ SET LINESIZE 200 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":74,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-339","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-5t","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/339","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=339"}],"version-history":[{"count":3,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/339\/revisions"}],"predecessor-version":[{"id":460,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/339\/revisions\/460"}],"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=339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}