declare -- Local variables here v_jobnum number; begin -- Test statements here dbms_job.submit(v_jobnum,'sp_Name;',sysdate,'last_day(sysdate)+1'); --dbms_output.put_line('job '||v_jobnum||' has been submitted.'); --dbms_job.run(v_jobnum,TRUE); --dbms_job.run(29,TRUE); --DBMS_JOB.REMOVE(6); COMMIT; end;
是不是缺参数啊也可以把instno设成0 variable jobno number; variable instno number; BEGIN select instance_number into :instno from v$instance; DBMS_JOB.SUBMIT(:jobno,'ctx_ddl.sync_index(''myindex'');', SYSDATE, 'SYSDATE + (1/24/4)',TRUE, :instno); commit; end;
-- Local variables here
v_jobnum number;
begin
-- Test statements here
dbms_job.submit(v_jobnum,'sp_Name;',sysdate,'last_day(sysdate)+1');
--dbms_output.put_line('job '||v_jobnum||' has been submitted.');
--dbms_job.run(v_jobnum,TRUE);
--dbms_job.run(29,TRUE);
--DBMS_JOB.REMOVE(6);
COMMIT;
end;
variable jobno number;
variable instno number;
BEGIN
select instance_number into :instno from v$instance;
DBMS_JOB.SUBMIT(:jobno,'ctx_ddl.sync_index(''myindex'');',
SYSDATE, 'SYSDATE + (1/24/4)',TRUE, :instno);
commit;
end;
你在sql*plus里面
exec ctx_ddl.sync_index(''myindex'');
能执行吗?
如果不行的话,就需要改一下了,把它放在存储过程里面处理。