ORACLE创建定时任务
declare
job binary_integer;
begin
dbms_job.submit(job => job,
what => 'DATA_MIGRATION_TOOL2.INSERT_INV_SNAP;',
next_date => sysdate
);
-- 记得哦
commit;
end;
declare
job binary_integer;
begin
dbms_job.submit(job => job,
what => 'DATA_MIGRATION_TOOL2.INSERT_INV_SNAP;',
next_date => sysdate
);
-- 记得哦
commit;
end;