Thnks Michal for your input,
All seems right for me:
SQL> show parameter job
NAME TYPE VALUE
------------------------------------ -------
------------------------------
job_queue_interval integer 90
job_queue_processes integer 2
Michal I cannot put next_date to 'sysdate+1/86400'
because this date will never be reached since I use
ALTER SYSTEM SET FIXED_DATE = sysdate+deta
Where the delta is the incremental time to simulate
pseudo-time in the future. And the main objective of
the procedure to do.
Ben
- Michal Zaschke <zaschke_at_suas.cz> wrote:
> Hi,
>
> 1) check job_queue_processes and job_queue_interval
> parameters in your
> init.ora file
> 2) have a commit after dbms_job.submit
> 3) if you want the procedure to be executed every
> second, then the next
> date should be 'sysdate+1/86400' =>
> dbms_job.submit(:job_num, 'myprocedure;',sysdate,
> 'sysdate+1/86400');
>
> Mike
>
> Kader Ben wrote:
> > Hi Listers,
> >
> > I'm simulating the date in future with
> fixed_date.
> > I wrote procedure to be called every seconde
> through
> > dbms_job to increment the fixed_date.
> >
> > I did that dbms_job.submit(:job_num,
> 'myprocedure;',
> > sysdate, 'sysdate');
> >
> > the dba_jobs table show me the right interval un
> > next_date:
> >
> >
> > BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC
> INTERVAL
> > N 13-JUN-03 00:00:00 13-JUN-03 17:50:06
> sysdate
> >
> > And the sysdate is:
> > 13-JUN-2003 17:50:06
> >
> > But the job never execute.
> >
> > Could you please give me hint how to resolve this
> > problem?
> >
> > Thanks you,
> >
> > Ben
> >
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Web Hosting - establish your business
> online
> > http://webhosting.yahoo.com
>
>
> --
> Ing. Michal Zaschke
> DB Administrator
> Sokolovska uhelna, a.s.
> tel.: +420 352 465417
> e-mail: zaschke_at_suas.cz
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Michal Zaschke
> INET: zaschke_at_suas.cz
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
>
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kader Ben
INET: kaderb_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Fri Mar 14 2003 - 08:33:48 CST
