Oracle?????????
???????????? ???????[ 2016/11/29 10:43:07 ] ????????????? Oracle
????????????????
????declare
????jobno number;
????begin dbms_job.submit(
????jobno??--?????ID??????????
????'PRC_INSERT;'??--what??е??????
????sysdate??--next_date????????????е????????д??????????
????'sysdate + 15/1440'--interval????????????е?????????д???15??????????
????);
????commit;
????end;
???????????????????????????????????????????isubmit????????
????????????????????е?????????????????????????д??????洢??????????????????????'pro_test;' (pro_test????????洢??????)
??????????????????????????????е??????????????????У??????sysdate
?????????????????????ò?????????????ε???????
????declare
????jobno
????number;
????begin
????dbms_job.remove(45);
????commit;
????end;
????exec dbms_job.remove(83);--???????????
????exec dbms_job.run(84);--????????????
????exec DBMS_JOB.BROKEN(83??SYS.DIUTIL.INT_TO_BOOL(1));--??????????
????exec DBMS_JOB.INTERVAL(84?? 'sysdate + 60/1440');--????????????????????????С???????
????select * from user_jobs??——??????????
????select * from dba_jobs_running??——????????е????????
????select * from dba_jobs??——???????????????
???????????????????
????myjob????????Submit()????????binary_ineger??????????????????????
????what???????????е?PL/SQL????飬?????????????洢???????????????????
????next_date????????????????????????дJ(rèn)ob?????????????????
????interval??????????????????????С?
????????interval????????ο?????????????
????1??????????
????Interval =>TRUNC(sysdate??’mi’) +1/ (24*60)
????2?????????
???????磺?????賿2?????
????Interval =>TRUNC(sysdate) +1+2/ (24)
????3??????????
???????磺?????賿2?????
????Interval =>TRUNC(next_day(sysdate??2))+2/24 --???????????????
????4??????????
???????磺???1???賿2?????
????Interval =>TRUNC(LAST_DAY(SYSDATE))+1+2/24
????5????????????
????????????????賿2?????
????Interval =>TRUNC(ADD_MONTHS(SYSDATE??3)??'Q') +2/24
????6???????????
???????磺???7??1???1??1???賿2??
????Interval =>ADD_MONTHS(trunc(sysdate??'yyyy')??6)+2/24
????7?????????
???????磺???1??1???賿2?????
????Interval =>ADD_MONTHS(trunc(sysdate??'yyyy')??12)+2/24
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11