这样试试
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'insert into A values(1);commit;',
sysdate, 'sysdate+1/(24*60)');
commit;
end;
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'insert into A values(1);commit;',
sysdate, 'sysdate+1/(24*60)');
commit;
end;
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'insert into A values('1); commit;',
sysdate, 'sysdate+1/(24*60)');
commit;
end;
就是这样才不行的
CREATE OR REPLACE PROCEDURE Procdemo AS
BEGIN
insert into A values(1);
commit;
END Procdemo;
/
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'Procdemo',
sysdate, 'sysdate+1/(24*60)');
commit;
end;
job_queue_processes 它指定每个例程的 SNP 作业队列进程的数量