Variable Job1 Number; BegindBMS_Job.Submit (: Job1, 'P_test1;', sysdate 1/1440, 'trunc (sysdate) 1 11/24');
Create or Replace Procedure P_dwryas begin Execute Immediate 'Truncate Table Tj_dwry'; INSERT INTO TJ_DWRY SELECT * from V_DWRY; Commital;
- Create JobVariable Job1 Number; BegindBMS_Job.Submit (: Job1, 'P_dwry;', sysdate, 'sysdate 1/1440'); - 1440 minutes a day, a minute running TEST procedure once; /
- Run job job.run (: job1); end; / - Delete JobBegin DBMS_Job.Remove (: JOB1); END; /
- Query Job Select Job, TO_CHAR (Next_DATE, 'YYYY-MM-DD HH24: MI: SS') from ALL_JOBS;
- View Current Time Select to_Char (Sysdate, 'YYYY-MM-DD HH24: MI: SS') from DUAL
