SQL> select to_char(sysdate,'HH:MI:SS'),TO_CHAR(SYSDATE+900/(24*60*60),'HH:MI:SS') FROM DUAL;

TO_CHAR( TO_CHAR(
-------- --------
10:24:29 10:39:29

SQL> SELECT TEXT FROM USER_SOURCE WHERE NAME='TEMPINS';

TEXT
---------------------------------------------------------------------
procedure tempins is
v_jn number;
begin
dbms_job.submit(v_jn,'myinm;',sysdate,'SYSDATE+900/(24*60*60)');
 COMMIT;
end;

procedure myinm
is
begin
  delete from tbl_inmacs1;
  insert into tbl_inmacs1(val_avg,val_min) select avg(val1),min(val1)
  from tbl_inmacs where name like 'A%';
  insert into tbl_inmacs1(val_avg_b,val_min_b) select avg(val1),min(val1)
  from tbl_inmacs where name like 'B%';
  commit;
 end;

SELECT job,
       to_char(last_date, 'DD-MON-YYYY HH24:MI:SS'),
       to_char(next_date,'DD-MON-YYYY HH24:MI:SS')
  FROM user_jobs
 WHERE ...

 1  SELECT job,
 2         to_char(last_date, 'DD-MON-YYYY HH24:MI:SS') as "last date",
 3         to_char(next_date,'DD-MON-YYYY HH24:MI:SS') as "next date"
 4*   FROM user_jobs
QL> /

     JOB last date            next date
-------- -------------------- --------------------
      21 05-JAN-2006 13:02:30 05-JAN-2006 13:02:40

SQL> select job from user_jobs;

      JOB
---------
       21

SQL> select interval from user_jobs where job=21;

INTERVAL
------------------------------------------------------
sysdate+(10/(24*60*60))

exec dbms_job.remove(21);
exec tempins;

SQL> select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') ,to_char
(sysdate+1/96, 'DD-MON-YYYY HH24:MI:SS') from dual;

TO_CHAR(SYSDATE,'DD-MON-YYYYH TO_CHAR(SYSDATE+1/96,'DD-MON-
----------------------------- -----------------------------
05-JAN-2006 14:32:26          05-JAN-2006 14:47:26