DECLARE
p_project_statis_job number;
Begin
dbms_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;