plsqldeveloperjob

A. oracle瀛樺偍榪囩▼濡備綍騫惰岋紵

A1 A2 A3涔熸槸瀛樺偍榪囩▼鍚楋紵 job鍏跺疄涓婁篃鍙鏄鍒嗗埆璋冪敤榪欏嚑涓榪囩▼鏉ユ墽琛岋紝鑰屼笉鏄闈犳墽琛屼竴涓獮灝卞彲浠ヨ╂墍鏈堿1 2 3 4 騫惰屾墽琛岀殑銆 濡傛灉A1 2 3 4閮芥槸闇瑕佸弬鏁扮殑璇濓紝閭ｄ箞浣犱篃鍙鏈夌敤A鍒嗗紑緇欐瘡涓涓閮戒紶閫掑弬鏁幫紝鍚﹀垯鐨勮瘽涔熸槸涓嶈兘騫惰屾墽琛岀殑銆 渚嬪傦細
declare n number
begin
dbms_job.submit('a1;a2;a3;a4',sysdate,'trunc(sysdate+1)');
commit;
end;
/
榪欐牱浼氳゛1 2 3 4鍒嗗埆鍚屾椂鎵ц岋紝浣犲彲浠ュ仛涓涓鏀瑰姩灝辨槸璁゛緇檃*浼犻掑弬鏁扮殑鍔ㄤ綔 鐩存帴鍔犲叆鍒癮 1 2 3 4鐨勮繃紼嬪綋涓鎵嶅彲浠ャ