oracle jobsÅú´¦ÀíÓï¾ä

--oracle jobsÅú´¦ÀíÃüÁî²Î¿¼
qlplus /nolog
connect sys/lee as sysdba
--ÒÔÏÂÁ½¾äÔÚsys(¼´¾ßÓÐdbaȨÏÞµÄÓû§)Óû§ÏÂÖ´ÐÐ
show parameter job_queue_processes;
alter system set job_queue_processes=10;
exit
sqlplus /nolog
connect jcy/jcy
ALTER TABLE T_OA_AFFICHE MODIFY (INPUT_TIME DATE);
ALTER TABLE T_OA_AFFICHE MODIFY (MODI_TIME DATE);
--±äÁ¿
variable job1 number;
--´´½¨job
begin
dbms_job.submit(:job1,'update T_OA_AFFICHE set STATE=0 where (trunc(sysdate)-trunc(INPUT_TIME))>A_VALIDITY;',sysdate,'TRUNC(sysdate+1)');
end;
/
--Ö´ÐÐ
begin
dbms_job.run(:job1);
end;
/
--±äÁ¿
variable job2 number;
--´´½¨job
begin
dbms_job.submit(:job2,'update t_oa_affiche set a_validity=a_validity+1 where state=0;',sysdate,'sysdate+1/(24*60)');
end;
/
--Ö´ÐÐ
begin
dbms_job.run(:job2);
end;
/
exit;