Change job (<10g)

March 2nd, 2012
BEGIN
SYS.DBMS_JOB.CHANGE
(
job => 30
,what => 'OWNER.PROC_NAME;'
,next_date => to_date('06/09/2007 00:15:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)+1/24/4'
);
END
/
Comments are closed.