oracle建定时任务

1、新建定时任务

DECLARE JOB NUMBER ;
BEGIN
	dbms_job.submit (
		JOB => JOB,
		what => 
'UPDATe  TEST T SET T.TEST_ITEM_TYPE_CODE = ''^OTHER^'' WHERe T.CODE IS NULL;',
		next_date => SYSDATE,
		INTERVAL => 'TRUNC(SYSDATE + 1) + （9*60）/(24*60)'
	) ;
	COMMIT ;
end;

2、查询定时任务

SELECT * FROM USER_JOBS;

3、删除定时任务

--删除自动执行的job
begin
  dbms_job.remove(2);  
  
  commit;
end;