variable job_MAKEZQJFD number;begin
dbms_job.summit(:job_MAKEZQJFD,'MAKEZQJFD',trunc(sysdate)+23/24,'trunc(sysdate)+1+23/24');
commit;
end;
dbms_job.summit(:job_MAKEZQJFD,'MAKEZQJFD',trunc(sysdate)+23/24,'trunc(sysdate)+1+23/24');
commit;
end;
job_MAKEZQJFD number;begin
dbms_job.summit(job_MAKEZQJFD,'MAKEZQJFD',trunc(sysdate)+23/24,'trunc(sysdate)+1+23/24');
commit;
end;
job_MAKEZQJFD number;begin
dbms_job.submit(job_MAKEZQJFD,'MAKEZQJFD;',trunc(sysdate)+23/24,'trunc(sysdate)+1+23/24');
commit;
end;
declare
job_MAKEZQJFD number;
begin
dbms_job.submit(job_MAKEZQJFD,'P_DS_ORG_LOADDATA;',trunc(sysdate)+23/24,'trunc(sysdate)+1+23/24');
commit;
end;
换个存储过程就执行过去了 查一下存储过程或者把错误贴出来看看
2.dbms_job.summit --> dbms_job.submit
3.dbms_job.submit调用时参数不对吧:
PROCEDURE submit ( job OUT BINARY_INTEGER,
what IN VARCHAR2,
next_date IN DATE DEFAULT sysdate,
interval IN VARCHAR2 DEFAULT 'null',
no_parse IN BOOLEAN DEFAULT FALSE, -- Bug 1346620: replace pkg vars with constants.
-- Default for instance = dbms_job.any_instance.
instance IN BINARY_INTEGER DEFAULT 0,
force IN BOOLEAN DEFAULT FALSE );