http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FUSER_JOBS
Oracle PL/SQL/System Tables Views/USER JOBS - История изменений
2026-04-07T02:57:15Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/USER_JOBS&diff=2340&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<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/System_Tables_Views/USER_JOBS&diff=2341&oldid=prev
Admin: 1 версия
2010-05-26T10:01:23Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> --<br />
SQL> SELECT JOB,WHAT,LAST_SEC,INTERVAL from USER_JOBS;<br />
JOB<br />
----------<br />
WHAT<br />
--------------------------------------------------<br />
LAST_SEC<br />
--------<br />
INTERVAL<br />
--------------------------------------------------<br />
21<br />
HELLO;<br />
18:12:52<br />
SYSDATE + (1/(24*60*60))<br />
22<br />
HELLO;<br />
18:12:52<br />
SYSDATE + (1/(24*60*60))<br />
41<br />
HELLO;<br />
SYSDATE + (1/(24*60*60))<br />
42<br />
HELLO;<br />
SYSDATE + (1/(24*60*60))<br />
<br />
4 rows selected.<br />
SQL><br />
SQL> --<br />
</source><br />
<br />
<br />
<br />
<br />
==user_jobs table==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> desc user_jobs<br />
Name Null? Type<br />
----------------------------------------------------- -------- ------------------------------------<br />
JOB NOT NULL NUMBER<br />
LOG_USER NOT NULL VARCHAR2(30)<br />
PRIV_USER NOT NULL VARCHAR2(30)<br />
SCHEMA_USER NOT NULL VARCHAR2(30)<br />
LAST_DATE DATE<br />
LAST_SEC VARCHAR2(8)<br />
THIS_DATE DATE<br />
THIS_SEC VARCHAR2(8)<br />
NEXT_DATE NOT NULL DATE<br />
NEXT_SEC VARCHAR2(8)<br />
TOTAL_TIME NUMBER<br />
BROKEN VARCHAR2(1)<br />
INTERVAL NOT NULL VARCHAR2(200)<br />
FAILURES NUMBER<br />
WHAT VARCHAR2(4000)<br />
NLS_ENV VARCHAR2(4000)<br />
MISC_ENV RAW(32)<br />
INSTANCE NUMBER<br />
SQL><br />
SQL> select job, what<br />
2 from user_jobs<br />
3 where broken = "Y";<br />
no rows selected<br />
SQL><br />
SQL> --<br />
</source><br />
<br />
<br />
<br />
<br />
==Viewing Your Own Jobs==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> SELECT JOB,WHAT,NEXT_DATE, NEXT_SEC, FAILURES,BROKEN<br />
2 from USER_JOBS<br />
<br />
</source></div>
Admin