CREATE OR REPLACE PROCEDURE update_attendance IS
    hr_date date := null;
    server_date date := null;
BEGIN
  select max(time_in) into hr_date from attendance@hr;
    select max(time_in) into server_date from attendance;
    if hr_date > server_date then
       insert into attendance 
       select * from attendance@hr a where a.time_in > server_date;
       commit;
    end if;
END update_attendance;

declare
  v_job number:=55;
begin
  dbms_job.SUBMIT(v_job,'update_attendance;',sysdate+10/86400,'sysdate+10/86400');
  dbms_output.put_line(v_job);
 
end;