Hi,

Surprise to see you after a long time.

For submitting the job in Oracle, foll. is the procedure.

begin
DBMS_JOB.ISUBMIT
(job => 12 --> or any number,
what => '',
next_date => trunc(sysdate) + 17/24 + 00/1440,
interval => 'sysdate + 1',
no_parse => FALSE);
commit;
end;

Above is just an example. Pl. replace the values in there appropriately.

How you manage to back those archived logs up before deleting them?

Thanks,