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镄勮繃绋嫔綋涓镓嶅彲浠ャ