Re: DBMS_JOBS

In message <1164230597.888210.196630_at_f16g2000cwb.googlegroups.com>, Gowree <gowreesan_at_gmail.com> writes
>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')
>
>

I assume last_date is null, implying the job has never run?

Try "show parameter job" in sqlplus.

This should show the setting for job_queue_processes. If this is 0, then jobs will not run.
>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>
>

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>