创建定时任务

创建定时任务

DECLAREp_project_statis_job number;
Begindbms_job.submit(job =>p_project_statis_job,what => 'zsjwh.insertyryfpsvalue(8888);',next_date => to_date('17-04-2021 11:30:00', 'dd-mm-yyyy hh24:mi:ss'),interval => 'SYSDATE+30/(60*24)');Commit;
End;

--------查看当前定时任务
select * from user_jobs;