Re: DBMS_JOBS

Carlos,
This is a simple script which invoke the database every 15 min and insert into temp table.
Forgot about the previous one....i just trying to do this simple one but it's not working
This PL/SQL statement compiled with any error but it's not running the job

declare

 x1 number;

BEGIN    DBMS_JOB.SUBMIT(
    x1,
'job1;' ,

    TRUNC(SYSDATE+1/144,'MI') ,
'trunc(sysdate+1/144,''MI'')'

);

  commit;

END; Received on Wed Nov 22 2006 - 12:48:25 CST