比如你创建的job号为22,你可以再procedure中这样调用:
create or replace procedure run_job is
begin
dbms_job.run(22);
end;--执行存储过程
execute run_job;
create or replace procedure run_job is
begin
dbms_job.run(22);
end;--执行存储过程
execute run_job;
dbms_scheduler.create_job
create or replace procedure run_job is
begin
dbms_scheduler.run_job(job_name => 'myjob');
end;--执行存储过程
execute run_job;