Thursday, January 31, 2008

Altering a JOB

In oracle 9i in order to alter a job you must enter all the parameters of the job even they remain the same.

e.g

BEGIN
SYS.DBMS_JOB.CHANGE
(
job => [job_number]
,what => 'begin myproc; end;'
,next_date => to_date('31/01/2008 10:40:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'sysdate+1/24'
);
commit;
END;
/

Here i changed only the "what" parameter but i included in my script the other 2.

No comments:

Post a Comment