declare
job_id pls_integer;
begin
sys.dbms_job.submit(job =>job_id,
what => 'begin shemaName.PkgName.SPName;end;',
next_date => to_date('01-03-2005', 'dd-mm-yyyy'),
interval => 'sysdate+1/24');
sys.dbms_job.broken(job =>job_id,
broken => true,
next_date => to_date('01-03-2005', 'dd-mm-yyyy'));
commit;
end;
job_id pls_integer;
begin
sys.dbms_job.submit(job =>job_id,
what => 'begin shemaName.PkgName.SPName;end;',
next_date => to_date('01-03-2005', 'dd-mm-yyyy'),
interval => 'sysdate+1/24');
sys.dbms_job.broken(job =>job_id,
broken => true,
next_date => to_date('01-03-2005', 'dd-mm-yyyy'));
commit;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货