http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fuser_jobs 2026-07-15T19:50:17Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_jobs&diff=3885&oldid=prev 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/user_jobs&diff=3886&oldid=prev 2010-05-26T10:08:04Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Query user_jobs==<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; select job, to_char(sysdate,&quot;dd-mon&quot;),<br /> 2 to_char(next_date,&quot;dd-mon-yyyy hh24:mi:ss&quot;),<br /> 3 interval, what<br /> 4 from user_jobs<br /> 5 /<br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> 21 25-jul 01-jan-4000 00:00:00<br /> SYSDATE + (10/(24*60*60))<br /> P_RUN_INSERT;<br /> 22 25-jul 01-jan-4000 00:00:00<br /> SYSDATE + (10/(24*60*60))<br /> P_RUN_INSERT;<br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> 41 25-jul 26-jul-2008 03:00:00<br /> TRUNC(SYSDATE+1) + 3/24<br /> GATHER_MY_STATS;<br /> 61 25-jul 25-jul-2008 19:34:32<br /> SYSDATE + 1/24<br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> LOG_SOURCE;<br /> 101 25-jul 01-jan-4000 00:00:00<br /> SYSDATE + (10/(24*60*60))<br /> P_RUN_INSERT;<br /> 82 25-jul 26-jul-2008 03:00:00<br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> trunc(sysdate)+1+3/24<br /> analyze_my_tables;<br /> 121 25-jul 01-jan-4000 00:00:00<br /> SYSDATE + (10/(24*60*60))<br /> P_RUN_INSERT;<br /> <br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> 122 25-jul 01-jan-4000 00:00:00<br /> SYSDATE + (10/(24*60*60))<br /> P_RUN_INSERT;<br /> 141 25-jul 25-jul-2008 21:18:41<br /> TRUNC(SYSDATE+1) + 3/24<br /> GATHER_MY_STATS;<br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> 161 25-jul 25-jul-2008 19:46:13<br /> SYSDATE + 1/24<br /> LOG_SOURCE;<br /> 162 25-jul 25-jul-2008 19:49:44<br /> SYSDATE + 1/24<br /> JOB TO_CHA TO_CHAR(NEXT_DATE,&quot;D<br /> ---------- ------ --------------------<br /> INTERVAL<br /> --------------------------------------------------------------------------------<br /> WHAT<br /> --------------------------------------------------------------------------------<br /> LOG_SOURCE;<br /> <br /> 11 rows selected.&lt;/source&gt;</div>

Admin