Re: submit a job

Do you have "job_queue_processes" parameter set in your <SID>init.ora file?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 09, 2002 9:48 AM

> Hello,
>
> I was submitted a job:
>
> VARIABLE jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno,
> 'sigvalue.check_shared_pool_reserve;',
> sysdate,'sysdate+1/144');
> commit;
> END;
> /
>
> SQL> select job,last_date,last_sec,next_date,next_sec,broken,interval
> from dba_jobs;
> JOB LAST_DATE LAST_SEC NEXT_DATE NEXT_SEC BROKEN INTERVAL
> ---------- ----------- -------- ----------- -------- ------
> 1 09/07/2002 15:20:11 09/07/2002 15:30:11 N sysdate + 1/
144
>
> time is moving but the job was not run.
> I tried to run it by exec dbms_job.run(1) and succeeded.
>
> What did I do wrong?
>
> thanks in advance
>
> Ofer Harel
> Barak ITC
> oharel_at_barak013.net.il
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ofer Harel
> INET: oharel_at_barak013.net.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).