Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±¼±-Oracle¼Æ»®ÈÎÎñ

SQL code:

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

begin
dbms_job.run(24);
end;

ORA-12011: ÎÞ·¨Ö´ÐÐ 1 ×÷Òµ
ORA-06512: ÔÚ "SYS.DBMS_IJOB", line 406
ORA-06512: ÔÚ "SYS.DBMS_JOB", line 272
ORA-06512: ÔÚ line 2


  ʲôԭÒò°¡
run Ç°ÃæµÄÄØ£¿


24 µÄJob ´´½¨³É¹¦µÄÂð£¿

²é¿´Ïà¹ØÐÅÏ¢¡¡¡¡
SQL>select JOB, NEXT_DATE, NEXT_SEC, FAILURES, BROKEN from DBA_JOBS;¡¡¡¡

ÕýÔÚÔËÐеÄJOBÏà¹ØÐÅÏ¢¡¡¡¡
select SID, r.JOB, LOG_USER, r.THIS_DATE, r.THIS_SEC from DBA_JOBS_RUNNING r, DBA_JOBS j where r.JOB = j.JOB;¡¡


ÆäʵÓÃTOAD¿´job£¬·Ç³£µÄ·½±ã..

Oracle dbms_job package Ó÷¨Ð¡½á
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4703133.aspx




   
24 µÄJob ´´½¨³É¹¦µÄÂð£¿
    ³É¹¦ÁË


°ÑÄãµÄJob Ìù³öÀ´¿´¿´£¬Äã¸øµÄÐÅϢ̫ÉÙÁË..

      µÈ

SQL code:

±»Á¬½Óµ½Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
±»Á¬½ÓΪkoala

SQL>
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'proc_auto_create_table;',to_date('2009-10-22 16:10:00','yyyy-mm-dd h


Ïà¹ØÎÊ´ð£º

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracle µ¼±í±¨´í

µ¼Èëpdmʱ±¨

D:\>imp ectrip_dmp/ectrip@orcl  file=d:\newjzg.pdm

Import: Release 10.1.0.2.0 - Production on ÐÇÆÚÎå 9ÔÂ 11 10:29:47 2009

Copyright (c) 1982, 2004, Oracle.&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ