Oracle Jobs Batch Statement ____oracle

--oracle Jobs Batch Command Reference Qlplus/nolog connect Sys/lee as SYSDBA--The following sentences are executed under the SYS (that is, a user with DBA authority) to perform the show parameter job_queue_proces Ses 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 variable JOB1 number; --Create 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 /--Perform the Begin Dbms_job.run (: JOB1); End /--variable variable JOB2 number; --Create 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 /--Perform the Begin Dbms_job.run (: JOB2); End /exit;