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;

posted @ 2024-02-23 15:47  小溪河北  阅读(71)  评论(0编辑  收藏  举报