Talk:DBMS JOB
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)
