rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 13th, 2008

 

This is the sample code you have to adjust time according to your requirement

SET AUTOPRINT ON
VAR jobno NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:jobno, 'JOBNAME;', TRUNC(SYSDATE) + 6/24,
'TRUNC(SYSDATE + 1) + 6.183/24');
COMMIT;
END;

Thanks
Rajiv
Gupta
Yogik Technologies Pvt. Ltd.