oracle数据库job相关操作

create or replace procedure p_test10
as
v_date varchar2(2);
begin
v_date:=to_char(sysdate,'hh24');
if v_date>='19' and v_date<='20'
then
insert into test10(id,je)values(1,1);
end if;
end;
--计划提交
--语法为
--dbms_job.submit(job out  binary_integer ,what => in varchar2,next_date => in date,interval => in varchar2,no_parse => in boolean,instance => in binary_integer,force => in boolean)
declare v_job number;
begin 
dbms_job.submit(v_job,'p_test10;',trunc(sysdate,'mi')+1/1440,'trunc(SYSDATE, ''mi'') + 5 / 1440');
end;
declare v_job number;
begin 
dbms_job.submit(v_job,'p_test10;',trunc(sysdate,'mi')+1/1440,'trunc(SYSDATE, ''mi'') + 5 / 1440');
end;
--dbms_job.broken()
begin
dbms_job.broken(41,false,to_date('2012-12-04 22:31:00','yyyy-mm-dd hh24:mi:ss'));
end;
--dbms_job.run()
begin
dbms_job.run(41);
end;
--修改JOB
begin
dbms_job.change(41,what =>'p_test10;',next_date => to_date('2012-12-04 22:36:00','yyyy-mm-dd hh24:mi:ss'),interval => 'trunc(SYSDATE, ''mi'') + 2 / 1440');
end;


--修改间隔
--语法为
--dbms_job.interval(job => ,interval => )
begin
dbms_job.interval(job => 41,interval => 'trunc(SYSDATE, ''mi'') + 1 / 1440');
end;
--修改下次启用时间
--语法为
--dbms_job.next_date(job => ,next_date => )
begin
dbms_job.next_date(job => 41,next_date => to_date('2012-12-04 22:36:00','yyyy-mm-dd hh24:mi:ss'));
end;
--remove
--语法为
--dbms_job.remove(job => in binary_integer)
begin
dbms_job.remove(41);
end;
--user_export()
--语法为
--dbms_job.user_export(job => ,mycall => in out varchar2)
declare callstr varchar2(200);
begin
dbms_job.user_export(job => 41,mycall => callstr);
dbms_output.put_line(callstr);
end;
输出为
dbms_job.isubmit(job=>41,what=>'p_test10;',next_date=>to_date('2012-12-04:23:04:00','YYYY-MM-DD:HH24:MI:SS'),interval=>'trunc(SYSDATE, ''mi'') + 1 / 1440',no_parse=>TRUE);
--dbms_job.what()
--相当于修改what部分的代码
begin
dbms_job.what(job => 41,what =>'p_test10;' );
/*dbms_output.put_line(callstr);*/
end;
--相关查询
select * from dba_jobs
select * from dba_jobs_running
select * from v$lock