dbms_job.submit - every sunday at 00:00 o'clock
463470May 15 2008 — edited May 16 2008Hello all,
I don't now exactly how these parameters work (next_date, interval)
I want this job to run every sunday at 00:00 o'clock or 01:00 clock on Monday.
Can anyone tell me if it is ok in this way?
Thank you!
declare
my_job number;
begin
dbms_job.submit(job => my_job,
what => 'my_procedure(test);'
next_date => 'TRUNC(SYSDATE+4)+1/24')),
interval => 'TRUNC(SYSDATE+7)+1/24'));
end;
/