Re: Auto-run batch processes in Oracle

--0__=AFZvFwDR1RerjBpFjffR6hHdIdRMtf8BiifNXUvYqF6UL8oopKvzWzyH Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Hello Gurus,

Thanks a lot for all your replies. It is working fine. The problem was with JOB_QUEUE_PROCESSES parameter in the initSID file.

Thanks again,
Shiva.

"Bert De Ridder" <b.deridder_at_nissan.be> on 06/22/2000 02:17:17 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: B Siva Shankar/MLs/TCSCHENNAI)

Subject: Re: Auto-run batch processes in Oracle

I don't know about other platforms, but I have to issue a commit after a dbms_job.submit
(7.3 on Netware)

Bert De Ridder
Nissan Belgium

Disclaimer : The opinions expressed in this message are my own,

                   and are not necessarily those of NV Nissan Belgium.

>>> "Libal, Ivo" <ivo.libal_at_knapp-systems.com> 21/06/2000 15:51:32 >>>
How many background job processes do you have? see init.ora params:
JOB_QUEUE_PROCESSES
JOB_QUEUE_INTERVAL
by default #of processes=0
Ivo Libal

> -----Urspr

--0__=AFZvFwDR1RerjBpFjffR6hHdIdRMtf8BiifNXUvYqF6UL8oopKvzWzyH

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

=FCngliche Nachricht-----
> Von: B Siva Shankar [SMTP:bsshankar_at_chennai.tcs.co.in]
> Gesendet am: Mittwoch, 21. Juni 2000 14:57
> An: Multiple recipients of list ORACLE-L
> Betreff: Re:Auto-run batch processes in Oracle
>
>
>
> Hello Guru,
>
> Thanks a lot. I have submitted one job to be executed at exactly a mi=
nute
> later
> than current time. The exact command is
>
> exec
> dbms_job.submit(:x,'batch_test;',sysdate+(1/1540),'sysdate+(1/1540)')=
;
>
> where batch_test is a procedure which inserts a record in a table and=

> commits.
> Then I checked for the
> next_date in dba_jobs for this job. It showed the expected time(i.e. =
one
> minute
> later than current time).
> But, when even after 5 minutes, I find no new records in the table. I=

> checked
> the alert log. But, found nothing
> abnormal.
>
> Can you please explain this?
>
> Shiva.
>
>
>
>
> dgoulet_at_vicr.com on 06/16/2000 07:56:02 PM
>
> To: B Siva Shankar/MLs/TCSCHENNAI_at_TCSCHENNAI, Multiple recipients o=
f
> list
> ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
>
>
> Shiva,
>
> Once you have the procedure written (functions I do not believe c=
an be
> used
> directly) then you can use the DBMS_JOB package to schedule the job. =
 Use
> the
> "submit" procedure whose's definition is:
>
> dbms_job.submit(job#, what_do_I_do, when_should_I_start, what_interva=
l,
> defer_parsing?);
>
> Where:
>
> job# is a number that will be returned.
> what_do_I_do is the procedure you want run (I think this can be a=

> PL/SQL block as well
> when_should_I_start is a date field, can be sysdate.
> What_interval is a character field that would evaluate to a date
> defer_parsing is a boolean that defaults to false. It tells the
> database whether to parse teh <what_do_I_do> field now or when f=
irst
> executed.
>
> Example that I have:
>
> declare
> job number;
> begin
> dbms_job.submit(job,
> 'data_archive.process_batch',
> trunc(sysdate)+(18/24),
> 'trunc(sysdate+1)+(18/24)',
> FALSE);
> dbms_output.put_line('Job Number is '||job);
> end;
> /
>
>
> ____________________Reply Separator____________________
> Author: "B Siva Shankar" <bsshankar_at_chennai.tcs.co.in>
> Date: 6/16/00 4:27 AM
>
>
>
> Hi List,
>
> Can any one tell me how to make a batch process run at a predetermine=
d
> time in
> ORACLE? This batch process can be a procedure or a function and shoul=
d run
> at
> regular intervals.
>
> Thanks,
> Shiva.
>
>
> --
> Author: B Siva Shankar
> INET: bsshankar_at_chennai.tcs.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing List=
s
> --------------------------------------------------------------------
> 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).
>
>
>
>
> --
> Author: B Siva Shankar
> INET: bsshankar_at_chennai.tcs.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing List=
s
> --------------------------------------------------------------------
> 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).

--
Author: Libal, Ivo
  INET: ivo.libal_at_knapp-systems.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).
--
Author: Bert De Ridder
  INET: b.deridder_at_nissan.be

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