oracle job µãµÎ

³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡£µ±job_queue_processֵΪ0ʱ±íʾȫ²¿Í£Ö¹oracleµÄjob£¬¿ÉÒÔͨ¹ýÓï¾ä
ALTER SYSTEM SET job_queue_processes = 10;
À´µ÷ÕûÆô¶¯oracleµÄjob¡£
Ïà¹ØÊÓͼ£º
dba_jobs
all_jobs
user_jobs
dba_jobs_running °üº¬ÕýÔÚÔËÐÐjobÏà¹ØÐÅÏ¢
 
£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­
Ìá½»jobÓï·¨£º
begin
sys.dbms_job.submit(job => :job,
                      what => 'P_CLEAR_PACKBAL;',
                      next_date => to_date('04-08-2008 05:44:09', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+ 1/360');
commit;
end;
/
 
£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­
´´½¨JOB
variable jobno number;
begin
dbms_job.submit(:jobno, 'P_CRED_PLAN;',SYSDATE,'SYSDATE+1/2880',TRUE);
commit;
ÔËÐÐJOB
SQL> begin
         dbms_job.run(:job1);
         end;
         /
ɾ³ýJOB
SQL> begin
        dbms_job.remove(:job1);
        end;
        /
DBA_JOBS
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
×ֶΣ¨ÁУ©          ÀàÐÍ             &nb