Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_JOBS
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 - 13:10:59 CST
![]() |
![]() |