17,140
社区成员




variable basecleanjob1 number;
begin
dbms_job.submit(:basecleanjob1 ,'insertbaseclean;',to_date('22-09-2008 01:00:00', 'dd-mm-yyyy hh24:mi:ss'),'trunc(sysdate+1) + 1/24');
commit;
end;
select job,last_date,next_date,broken from user_jobs;