http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fdba_jobs Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba jobs - История изменений 2026-07-15T22:24:18Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_jobs&diff=3921&oldid=prev в 13:45, 26 мая 2010 2010-05-26T13:45:46Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_jobs&diff=3922&oldid=prev Admin: 1 версия 2010-05-26T10:08:08Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Query dba_jobs for job information==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT what, job, priv_user,<br /> 2 TO_CHAR(last_date, &quot;MM/DD/YYYY HH24:MI:SS&quot;) last,<br /> 3 DECODE(this_date, NULL, &quot;NO&quot;, &quot;YES&quot;) running,<br /> 4 TO_CHAR(next_date, &quot;MM/DD/YYYY HH24:MI:SS&quot;) next,<br /> 5 interval, total_time, broken<br /> 6 FROM dba_jobs<br /> 7 where rownum &lt; 50<br /> 8 ORDER BY what;<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> GATHER_MY_STATS;<br /> 141 sqle NO<br /> 07/25/2008 18:06:31<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> TRUNC(SYSDATE+1) + 3/24<br /> 1 N<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> GATHER_MY_STATS;<br /> 41 sqle NO<br /> 07/26/2008 03:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> TRUNC(SYSDATE+1) + 3/24<br /> 1 N<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> LOG_SOURCE;<br /> 61 sqle NO<br /> 07/25/2008 18:34:31<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + 1/24<br /> 1 N<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> LOG_SOURCE;<br /> 161 sqle NO<br /> 07/25/2008 17:50:04<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + 1/24<br /> 0 N<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> P_RUN_INSERT;<br /> 101 sqle NO<br /> 01/01/4000 00:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + (10/(24*60*60))<br /> 2 Y<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> P_RUN_INSERT;<br /> 121 sqle NO<br /> 01/01/4000 00:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + (10/(24*60*60))<br /> 3 Y<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> P_RUN_INSERT;<br /> 122 sqle NO<br /> 01/01/4000 00:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + (10/(24*60*60))<br /> 2 Y<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> P_RUN_INSERT;<br /> 22 sqle NO<br /> 01/01/4000 00:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + (10/(24*60*60))<br /> 0 Y<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> P_RUN_INSERT;<br /> 21 sqle NO<br /> 01/01/4000 00:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> SYSDATE + (10/(24*60*60))<br /> 3 Y<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> analyze_my_tables;<br /> 82 sqle 07/25/2008 17:34:31 NO<br /> 07/26/2008 03:00:00<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> trunc(sysdate)+1+3/24<br /> 5 N<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs =&gt; 24);<br /> 4001 FLOWS_020100 07/25/2008 17:34:31 NO<br /> 07/26/2008 01:34:31<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> sysdate + 8/24<br /> 12 N<br /> <br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> wwv_flow_mail.push_queue(wwv_flow_platform.get_preference(&quot;SMTP_HOST_ADDRESS&quot;),w<br /> wv_flow_platform.get_preference(&quot;SMTP_HOST_PORT&quot;));<br /> 4002 FLOWS_020100 07/17/2008 19:37:40 NO<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> 01/01/4000 00:00:00<br /> sysdate + 10/1440<br /> 16 Y<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> JOB PRIV_USER LAST RUN<br /> ---------- ------------------------------ ------------------- ---<br /> NEXT<br /> -------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> TOTAL_TIME B<br /> ---------- -<br /> <br /> 12 rows selected.<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;</div> Admin