Talk:DBMS JOB

From Oracle FAQ
Jump to: navigation, search

my system is linux oracle is 10g upade 4

SQL> select * from v$version;

BANNER


Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production

SQL>


in my database all job cannot execute at the time SQL> select * from dba_jobs where job=24;

      JOB LOG_USER                       PRIV_USER                      SCHEMA_USER                    LAST_DATE   LAST_SEC         THIS_DATE   THIS_SEC         NEXT_DATE   NEXT_SEC         TOTAL_TIME BROKEN INTERVAL                                                                           FAILURES WHAT                                                                             NLS_ENV                                                                          MISC_ENV                                                           INSTANCE

------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
       24 dddd_2                         dddd_2                         dddd_2                         2011-12-2 1 13:05:09                                      2011-12-2 1 13:06:09                  0 N      sysdate+1/1440                                                                            0 prc_g_test;                                                                      NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='¥' NLS_ISO 0102000200000000    
                                                     0


dbms_job.run is ok


SQL> SQL> begin

 2  dbms_job.run(24);      
 3  end;
 4  /

PL/SQL procedure successfully completed

SQL> SQL> select * from dba_jobs where job=24;

      JOB LOG_USER                       PRIV_USER                      SCHEMA_USER                    LAST_DATE   LAST_SEC         THIS_DATE   THIS_SEC         NEXT_DATE   NEXT_SEC         TOTAL_TIME BROKEN INTERVAL                                                                           FAILURES WHAT                                                                             NLS_ENV                                                                          MISC_ENV                                                           INSTANCE

------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
       24 DMGY_2                         DMGY_2                         DMGY_2                         2011-12-2 1 13:42:59                                      2011-12-2 1 13:43:59                  0 N      sysdate+1/1440                                                                            0 prc_g_test;                                                                      NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='¥' NLS_ISO 0102000200000000                                                          0

SQL>


==========================parameter=========[edit]

SQL> show parameter job

NAME TYPE VALUE


----------- ------------------------------

job_queue_processes integer 10

SQL> select instance_name,logins from v$instance;

INSTANCE_NAME LOGINS


----------

dmgy ALLOWED

SQL>


so i do not know why?

-------------------
Wiki is not the place to post a question but new page or comment on page.
Try to post it on Forum: http://www.orafaq.com/forum/i/102589/ without forget to before read OraFAQ Forum Guide (http://www.orafaq.com/forum/t/88153/0/) and "How to use [code] tags" topic (http://www.orafaq.com/forum/t/171557/102589/) and make your code easier to read, and keep your lines of code in 80 character width: no more than 80 characters on each line..
Michel Cadot 16:24, 2 December 2011 (UTC)