Oracle PL/SQL Tutorial/System Tables Data Dictionary/user jobs

Материал из SQL эксперт
Версия от 10:08, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

Query user_jobs

SQL>
SQL> select job, to_char(sysdate,"dd-mon"),
  2                    to_char(next_date,"dd-mon-yyyy hh24:mi:ss"),
  3                    interval, what
  4  from user_jobs
  5  /
       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
        21 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60))
P_RUN_INSERT;
        22 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60))
P_RUN_INSERT;
       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
        41 25-jul 26-jul-2008 03:00:00
TRUNC(SYSDATE+1) + 3/24
GATHER_MY_STATS;
        61 25-jul 25-jul-2008 19:34:32
SYSDATE + 1/24
       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
LOG_SOURCE;
       101 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60))
P_RUN_INSERT;
        82 25-jul 26-jul-2008 03:00:00
       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
trunc(sysdate)+1+3/24
analyze_my_tables;
       121 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60))
P_RUN_INSERT;

       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
       122 25-jul 01-jan-4000 00:00:00
SYSDATE + (10/(24*60*60))
P_RUN_INSERT;
       141 25-jul 25-jul-2008 21:18:41
TRUNC(SYSDATE+1) + 3/24
GATHER_MY_STATS;
       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
       161 25-jul 25-jul-2008 19:46:13
SYSDATE + 1/24
LOG_SOURCE;
       162 25-jul 25-jul-2008 19:49:44
SYSDATE + 1/24
       JOB TO_CHA TO_CHAR(NEXT_DATE,"D
---------- ------ --------------------
INTERVAL
--------------------------------------------------------------------------------
WHAT
--------------------------------------------------------------------------------
LOG_SOURCE;

11 rows selected.
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/user_jobs&oldid=3886»