SQL & PL/SQL

Hello All,

Orcl Version: 11g

I scheduled to run a job every 10 minutes.

Is there a way to make it run exactly at every 10th minute?

This is the script that I used to schedule it run for the first time at 12:00:00 PM.

begin
  sys.dbms_job.submit(job => :job,
                      what => 'AMD.alerts.get_mismatch;',
                     next_date => to_date('10-08-2016 12:00:00', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+10/1440');
  commit;
end;

The second run is scheduled to run at 12:10:29.

But how do we make it run at 12:10:00 (There's a lag of 29 seconds)

begin
  sys.dbms_job.submit(job => :job,
                      what => 'AMD.alerts.get_mismatch;',
                     next_date => to_date('10-08-2016 12:10:29', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate+10/1440');
  commit;
end;

Appreciate any help.

Thanks,

Shan.