Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Job submitted with DBMS_JOB wont run --> Solved!

Re: Job submitted with DBMS_JOB wont run --> Solved!

From: Patrick J. <patrickREMOVE.jTHIS_at_kneip.com>
Date: Thu, 6 Jun 2002 14:23:32 +0200
Message-ID: <3cff5445$1_2@news.vo.lu>


Thanks to you all, I effectively omitted to issue a commit after the submit ...

"Patrick J." <patrickREMOVE.jTHIS_at_kneip.com> wrote in message news:3cfb8e22_1_at_news.vo.lu...
> Hi,
>
> I submitted a job via DBMS_JOB.SUBMIT. This was accepted and I can see the
> job in USER_JOBS view.
> But the job never starts (the last date is always null).
>
> The parameters seem to be OK:
> job_queue_interval=60
> job_queue_processes=4
>
> I can even see the snp processes when issuing a 'ps' command, but nothing
> happens.
>
> The database is 8.1.7 running on Suse Linux 7.2.
>
> What is wrong?
>
> Patrick J.
>
>
Received on Thu Jun 06 2002 - 07:23:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US