VARIABLE uds NUMBER;
begin
sys.dbms_job.submit(job => :uds,
what => 'upc_data_sync;',
next_date => to_date('20-03-2012 03:17:04', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/8');
commit;
end;
/
begin
sys.dbms_job.submit(job => :uds,
what => 'upc_data_sync;',
next_date => to_date('20-03-2012 03:17:04', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate)+1+1/8');
commit;
end;
/