Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_JOBS

Re: DBMS_JOBS

From: Jim Smith <usenet_at_ponder-stibbons.com>
Date: Wed, 22 Nov 2006 19:10:59 +0000
Message-ID: <sG3+dXmDDKZFFwi7@jimsmith.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US