DECLARE job NUMBER;
begin
sys.dbms_job.submit(job => job,
what => 'jzzccde.acclog_packge0.job_002;',
next_date => to_date('24-04-2012 09:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate-2-9/24,''D'')+9+9/24');
commit;
end;
begin
sys.dbms_job.submit(job => job,
what => 'jzzccde.acclog_packge0.job_002;',
next_date => to_date('24-04-2012 09:00:00', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate-2-9/24,''D'')+9+9/24');
commit;
end;