Oracle job ¹ÜÀí£¨×ªÔØ£©

Oracle job ¹ÜÀí
 
 
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000  ;job_queue_interval = 10  //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the current user
1  select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)
2 select job,what,last_date,next_date,interval from  dba_jobs where job in (1,3);
²éѯjobµÄÇé¿ö¡£
show paramter background_dump_dest.
¿´alter.log ºÍtrace
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000
job_queue_interval = 10  //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JOBS describes all jobs owned by the current user
1  select job,what,to_char(last_date,'yyyy-mm-dd HH24:mi:ss'),to_char(next_date,'yyyy-mm-dd HH24:m),interval from dba_jobs where job in (325,295)
2 select job,what,last_date,next_date,interval from  dba_jobs where job in (1,3);
²éѯjobµÄÇé¿ö¡£
show paramter background_dump_dest.
¿´alter.log ºÍtrace
ÇëÎÊÎÒÈçºÎÍ£Ö¹Ò»¸öJOB
SQL> exec dbms_job.broken(1,true)
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
SQL>commit  //±ØÐëÌá½»·ñÔòÎÞЧ
Æô¶¯×÷Òµ
SQL> exec dbms_job.broken(1,false)
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
Í£ÆäËûÓû§µÄjob
SQL>exec sys.dbms_ijob.broken(98,true);
SQL>commit;
============================
exec dbms_job.broken(:job) ֹͣ
exec dbms_job.broken(186,true) //±ê¼Çλbroken
exec dbms_job.broken(186,false)//±ê¼ÇΪ·Çbroken
exec dbms_job.broken(186,false,next_day(sysdate,'monday')) //±ê¼ÇΪ·Çbroken,Ö¸¶¨Ö´ÐÐʱ¼ä
exec dbms_job.remove(:job)£»É¾³ý
exec dbms_job.remove(186);
commit£»
°ÑÒ»¸öbroken jobÖØÐÂÔËÐÐ
Èý¡¢²é¿´Ïà¹ØjobÐÅÏ¢
1¡¢Ïà¹ØÊÓͼ
dba_jobs
all_jobs
user_jobs
dba_jobs_running °üº¬ÕýÔÚ