Change job (<10g)


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

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
/