Re: DBMS_JOB

I had a similar problem. Mine started working when I manually ran the job forthe first time:

execute dbms_job.run(JobNum);

You got the JobNum when you submitted it, and you can get it by querying dba_jobs.

Djordje

• Original Message ----- From: Nikunj Gupta <good_dba_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Saturday, November 25, 2000 1:55 AM Subject: Re: DBMS_JOB

> If you have Job Queue Process set to 2 .. then max of 2 jobs can be
> executed.. If you submit the 3rd job.. it will be successfully submitted
but
> never executed..
>
> Since you have only 1 job.. that should not be the limitation..
>
>
> You can try deleting this job.. and resubmitting..
>
> COMMIT after END;
>
> and check whether the job is executed in minutes after submission or not..
> Since you are using SYSDATE as the current parameter.. it should be
executed
> immediately automatically.
>
> HTH
>
> Nikunj
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, November 22, 2000 03:00 AM
>
>
> > I have the same setting in my Init.ora parameter. Infact, If I try and
> > execute using DBMS_JOB.RUN(1), its executing the process.
> >
> > Any thoughts?
> >
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, November 21, 2000 6:53 PM
> > To: ORACLE-L_at_fatcity.com; raj.gopalan_at_netdecisions.co.uk
> >
> >
> > Make sure you set the job_queue_processes and job_queue_interval
init.ora
> > parameters. Ours are set to 2 and 60 respectively.
> >
> >
> >
> > Jay Hostetter
> > Oracle DBA
> > D. & E. Communications
> > Ephrata, PA USA
> >
> > >>> Raj Gopalan <raj.gopalan_at_netdecisions.co.uk> 11/21/00 12:45PM >>>
> > Hi all
> >
> > I need to schedule a procedure using dbms_job.
> >
> > I created it using the following script.
> >
> > declare
> > jobno number;
> > begin
> > dbms_job.submit(jobno,'SP_MANUAL_REPLICATION;', sysdate,'sysdate+1');
> > commit;
> > end;
> >
> >
> > For some reason it not running at all.
> >
> > Any thoughts?
> >
> > TIA
> >
> > Raj
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Raj Gopalan
> > INET: raj.gopalan_at_netdecisions.co.uk
> >
> > 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: Raj Gopalan
> > INET: raj.gopalan_at_netdecisions.co.uk
> >
> > 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: Nikunj Gupta
> INET: good_dba_at_hotmail.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
Received on Sat Nov 25 2000 - 08:22:43 CST