navicat创建oracle job
declare job number; begin sys.dbms_job.submit(job => job, what => 'null;', next_date => to_date('22-12-2021 00:40:02', 'dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(sysdate)+1'); commit; end; /
查看job:
select * from user_jobs;
declare job number; begin sys.dbms_job.submit(job => job, what => 'null;', next_date => to_date('22-12-2021 00:40:02', 'dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(sysdate)+1'); commit; end; /
查看job:
select * from user_jobs;