DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => ‘ORHAN.SIZE_TABLESPACES;’
,next_date => to_date(‘24.02.2009 00:00:00′,’dd/mm/yyyy hh24:mi:ss’)
,interval => ‘TRUNC(SYSDATE+1)’
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE(‘Job Number is: ‘ || to_char(x));
COMMIT;
END;
/

Reklam