Oracle JOBµÄ½¨Á¢£¬¶¨Ê±Ö´ÐÐÈÎÎñ
begin
sys.dbms_job.submit(job => :job,
what => 'check_err;',
next_date => trunc(sysdate)+23/24,
interval => 'trunc(next_day(sysdate,''ÐÇÆÚÎå''))+23/24');
commit;
end;
ÆäÖÐ:jobÊÇϵͳ×Ô¶¯²úÉú±àºÅ£¬check_errÊÇÎÒµÄÒ»¸ö¹ý³Ì£¬next_dateÉèÖÃÏ´ÎÖ´ÐÐʱ¼ä£¬ÕâÀïÊǽñÌìÍíÉÏ23£º00£¬interval
ÉèÖÃʱ¼ä¼ä¸ô£¬¶à¾ÃÖ´ÐÐÒ»´Î£¬ÕâÀïÊÇÿÖܵÄÐÇÆÚÎåÍíÉÏ23£º00£¬º¯Êýnext_day·µ»ØÈÕÆÚÖаüº¬Ö¸¶¨×Ö·ûµÄÈÕÆÚ£¬trunc
º¯ÊýÈ¥µôÈÕÆÚÀïµÄʱ¼ä£¬Ò²¾ÍÊǵõ½µÄÊÇijÌìµÄ00:00£¬Ê±¼äÊÇÒÔÌìΪµ¥Î»µÄËùÒÔÒªµÃµ½Ä³Ä³µãijij·Ö£¬¾ÍÐèÒª·ÖÊý£º
1/24 һСʱ£»
1/1440 Ò»·Ö£»
1/3600 Ò»Ã룻
Ïà¹ØÎĵµ£º
ÔÚ´ò°üoralce¿Í»§¶Ëºó£¬¾³£»áÓöµ½Õâ¸öÎÊÌâ“specified class not registered in registry”
½â¾ö°ì·¨£º
ÕâÊÇÒòΪÓм¸¸öÁ´½Ó¿âdll»òocxûע²áµÄÔÒò£¬¾±¾È˲âÊÔΪÒÔÏÂ5¸öÎļþ£º
......
¹ØÓÚдÐò£¬È˵ÄÒ»±²×ÓÓкܶàµÄµÚÒ»´Î£¬¸øÊéдÐò£¬¶ÔÎÒÀ´ËµÒ²ÊǵÚÒ»´Î£¬¶øÇÒÊǺÜÄѵõÚÒ»´Î¡£Ò»°ãÈËÊéдÍêÁË£¬¶¼»áÕÒÒ»¸öÓеãÃûÆøµÄÈËÀ´ÎªÖ®×öÐò£¬ÔÚÕâÀïÎÒÖ»ÄܲÑÀ¢Ò»ÏÂ
¡£ÒòΪÎÒ×ܾõµÃ¸øÒ»±¾ÊéдÐòµÄÈË£¬ÔÚÊéµÄÄÚÈÝ·½Ã棬ÖÁÉÙÒ²µÃÊÇ°ë¸öר¼Ò£¬È»ºó²ÅÄÜÓз¢ÑÔȨ¡£¶ø±¾ÈËÔÚoracle·½Ã棬Á¬°ëÍ°Ë®µÄËã²»ÉÏ¡£ÕâÒ»´ÎÒ²¿ÖÅÂÖ»ÄÜÊÇ ......
жÔØOracle £º
1¡¢Í£Ö¹ËùÓÐOracle·þÎñ£¬µãUniversal InstallerжÔØ
2¡¢É¾³ý×¢²á±íÖеÄËùÓйØÓÚOracleÏî
£¨1£©ÔÚHKEY_LOCAL_MACHINE\SOFTWAREÏ£¬É¾³ýOracleĿ¼
£¨2£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨3£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\ServicesÏ£¬É¾³ýË ......
racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà 2009-12-23 18:17 ÔĶÁ43 ÆÀÂÛ0 ×ֺţº ´ó´ó ÖÐÖРСС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄתÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë
......