È«ÃæѧϰORACLE SchedulerÌØÐÔ(2)¹ÜÀíjobs
1.2 ¹ÜÀíJobs
1.2.1 ÆôÓÃJobs
¡¡¡¡Ç°Ãæ´´½¨JOBʱ£¬ÓÉÓÚδÏÔʽµÄÖ¸¶¨ENABLED²ÎÊý£¬Òò´Ë¼´Ê¹Ö¸¶¨ÁËSTART_DATE£¬²»¹ýĬÈÏÇé¿öÏÂJOB²»»á×Ô¶¯Ö´ÐС£¶ÔÓÚÕâÖÖÇé¿ö£¬DBMS_SCHEDULER°üÖÐÌṩÁËÒ»¸ö¹ý³ÌENABLE£¬¿ÉÒÔÓÃÀ´ÐÞ¸ÄJOBµÄÆôÓÃ״̬£¬µ÷Ó÷½Ê½·Ç³£¼òµ¥£¬ÀýÈ磺
SQL> exec dbms_scheduler.enable(¨INSERT_TEST_TBL¨);
PL/SQL procedure successfully completed.
1.2.2 ½ûÓÃJobs
¡¡¡¡DBMS_SCHEDULER.ENABLE ½öÓÃÀ´½«JOB(Æäʵ²»½ö½ö¶ÔJOBÓÐЧ£¬¶ÔÓÚCHAIN¡¢PROGRAMµÈÒ²ÓÐЧ)µÄÆôÓÃ״̬ÖÃΪTRUE¡£Èç¹ûÏ뽫ÆäÆôÓÃ״̬ÖÃΪFALSE£¿¼òµ¥£¬»¹ÓÐÒ»¸öÓë¸Ã¹¦ÄܶÔÓ¦µÄ¹ý³Ì£ºDBMS_SCHEDULER.DISABLE£¬ÀýÈ磺
SQL> exec dbms_scheduler.disable(¨INSERT_TEST_TBL¨);
PL/SQL procedure successfully completed.
¡¡¡¡ÕâÁ½¸ö¹ý³Ì½öÓÃÀ´ÖØÖöÔÏóµÄ״̬£¬Òò´Ë¾ù¿ÉÒÔÎÞÏÞ´ÎÖ´ÐУ¬¼´Ê¹Ö´ÐÐʱ¶ÔÏóÒѾ±»ÖÃΪҪָ¶¨µÄ״̬¡£
1.2.3 ÐÞ¸ÄJobs
¡¡¡¡ÓÉÓÚJOBµÄÊôÐÔÖڶ࣬ÄÑÃâʱ²»Ê±µÄ¿ÉÄÜ»áÓöµ½ÐèÒªÐ޸ĵÄÇé¿ö£¬±ÈÈç˵ǰÃæ´´½¨JOBʱ²»Ð¡ÐÄ£¬Ö¸¶¨ÒªÖ´ÐеĹý³ÌÃûÊäÈë´íÎó(ÍêÈ«ÓпÉÄÜ£¬CREATE_JOBÔÚ´´½¨Ê±²»»á×Ô¶¯¼ì²éÖ¸¶¨µÄ¹ý³ÌÊÇ·ñÓÐЧ£¬´ÓÕâ·½Ã濼ÂÇ£¬SCHEDULER²»ÈçÆÕͨJOBÑϽ÷ÄÄ)£¬ÕâÖÖÇé¿öϾͱØÈ»Éæ¼°µ½¶ÔJOBµÄÐÞ¸Ä(»òÕß˵Öض¨Òå)£¬Ã»ÎÊÌ⣬DBMS_SCHEDULER°üÖÐרÃÅÌṩÁËÒ»¸ö¹ý³ÌSET_ATTRIBUTE£¬¿ÉÒÔÓÃÀ´ÐÞ¸ÄÈÎÎñµÄÊôÐÔÖµ¡£
¡¡¡¡ÀýÈ磬Ð޸ĸոմ´½¨µÄJOB£ºINSERT_TEST_TBLÖ´ÐеĹý³Ì£¬Ö´ÐÐÓï¾äÈçÏ£º
SQL> exec dbms_scheduler.set_attribute(¨INSERT_TEST_TBL¨,¨JOB_ACTION¨,¨P_ INSERT INTOTEST¨);
PL/SQL procedure successfully completed
¡¡¡¡µ±È»À²£¬ÎÒÃÇÕâÀïÖ´ÐеÄÕâÌõÓï¾ä£¬Ö´ÐиúûִÐÐûÓÐÇø±ð£¬´Ë´¦½ö×öʾÀý£¬´ó¼Ò±íÉ¡£
¡¡¡¡SET_ATTRIBUTE ¹ý³ÌËäÈ»½öÓÐÈý¸ö²ÎÊý£¬²»¹ýÄܹ»Ð޸ĵÄÊôÐÔÖµ¿ÉÊDz»ÉÙ£¬ÒÔÏÂÁоټ¸¸ö½Ï³£Óõ½µÄ£º
LOGGING_LEVEL £ºÖ¸¶¨¶ÔjobsÖ´ÐÐÇé¿ö¼Ç¼µÄÈÕÖ¾ÐÅÏ¢¼¶±ð¡£
SCHEDULER ¹ÜÀíµÄJOB¶ÔÈÎÎñµÄÖ´ÐÐÇé¿öרÃŽøÐÐÁ˼Ǽ£¬Í¬Ê±Óû§»¹¿ÉÒÔÑ¡ÔñÈÕÖ¾ÖмǼÐÅÏ¢µÄ¼¶±ð£¬ÓÐÏÂÁÐÈýÖÖÑ¡Ôñ£º
DBMS_SCHEDULER.LOGGING_OFF £º¹Ø±ÕÈÕÖ¾¼Ç¼¹¦ÄÜ£»
DBMS_SCHEDULER.LOGGING_RUNS £º¶ÔÈÎÎñµÄÔËÐÐÐÅÏ¢½øÐмǼ£»
DBMS_SCHEDULER.LOGGING_FULL £º¼Ç¼ÈÎÎñËùÓÐÏà¹ØÐÅÏ¢£¬²»½öÓÐÈÎÎñµÄÔËÐÐÇ
Ïà¹ØÎĵµ£º
±í´Ø£¨table cluster)ÊÇÒ»¸öÊý¾Ý¿â¶ÔÏó£¬Ëü¿ÉÒÔ½«ÄÇЩ¾³£ÔÚÏàͬÊý¾Ý¿éÖÐÒ»ÆðʹÓõıí½øÐÐÎïÀí·Ö×é¡£µ±Äã´¦ÀíÄÇЩ¾³£Á¬½ÓÔÚÒ»Æð½øÐвéѯµÄ±íʱ£¬±í´ØÊÇÌرðÓÐЧµÄ¡£Ò»¸ö±í´Ø´æ´¢´Ø¼ü£¨ÓÃÓÚ½«±íÁ¬½Óµ½Ò»ÆðµÄÁУ©£¬ÒÔ¼°´Ø±íÖеÄÁÐÖµ¡£ÒòΪ´ØÖÐµÄ±í¶¼±»´¢´æÔÚÏàͬµÄÊý¾Ý¿â¿éÖУ¬ËùÒÔʹÓôع¤×÷ʱ£¬I/O²Ù×÷¾Í¼õÉÙÁË¡£
......
1.½¨±í£¬²åÈëÊý¾Ý
create table dept(deptno number,deptname varchar2(20),mgrno number);
insert into dept values(1,'×ܹ«Ë¾',null);
insert into dept values(2,'Õã½·Ö¹«Ë¾',1);
insert into dept values(3,'º¼ÖÝ·Ö¹«Ë¾',2);
insert into dept values(4,'ºþ±±·Ö¹«Ë¾',1);
insert into dept values(5,'Î人·Ö¹«Ë¾ ......
ÎÒÃÇ¿ÉÄÜÔÚOracle DB10g Öлᾳ£Óöµ½OEM²»ÄÜÕý³£Ê¹ÓõÄÎÊÌâ,µ¼ÖÂÎÊÌâµÄÔÒò²»¾¡Ïàͬ,
µ«×îºó¾ø´ó¶àÊýÎÊÌâ¿ÉÒÔͨ¹ýemca Õâ¸öÃüÁîÀ´½â¾ö,ÏêϸµÄ˵Ã÷¿ÉÒԲ鿴Á¬»ú°ïÖú,
ÏÂÃæ¸ø³öһЩ³£ÓõÄÃüÁî,¼°ÊµÀý²½Öè.
´´½¨Ò»¸öEM×ÊÁÏ¿â
emca -repos create
Öؽ¨Ò»¸öEM×ÊÁÏ¿â
emca -repos r ......
Oracle 10g ĬÈÏ°²×°´øÀ´µÄÓû§Ãû/ÃÜÂë
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enter ......