Jim,
when i select the
'select * from user_jobs'
it display the job # and next date,next sec,total time =0 and broken=N.
interval as trunc(sysdate+1/144,'MI')
Jim Smith wrote:
> In message <1164221305.683722.284960_at_h48g2000cwc.googlegroups.com>,
> Gowree <gowreesan_at_gmail.com> writes
> >
> >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;
> >
> What does 'select * from user_jobs' show?
> --
> Jim Smith
> Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
> RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Wed Nov 22 2006 - 15:23:17 CST
