SQL> variable job1 NUMBER;
SQL> ;
SQL> BEGIN
2 dbms_job.submit(:job1,'ProTest;',SYSDATE,'sysdate+1/1440'); //创建作业
3 END;
4 /
PL/SQL procedure successfully completed
job1
---------
93
SQL> BEGIN
2
3 dbms_job.run(:job1); //执行作业
4 END;
5 /