From: "Patrick J." <patrickREMOVE.jTHIS@kneip.com>
Newsgroups: comp.databases.oracle.server
References: <3cfb8e22_1@news.vo.lu>
Subject: Re: Job submitted with DBMS_JOB wont run --> Solved!
Date: Thu, 6 Jun 2002 14:23:32 +0200
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: ppp294.vo.lu
Message-ID: <3cff5445$1_2@news.vo.lu>
X-Trace: news.vo.lu 1023366213 ppp294.vo.lu (6 Jun 2002 14:23:33 +0200)
Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!npeer.kpnqwest.net!EU.net!news.vo.lu!not-for-mail
Xref: easynews comp.databases.oracle.server:149737
X-Received-Date: Thu, 06 Jun 2002 05:40:52 MST (news.easynews.com)

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

"Patrick J." <patrickREMOVE.jTHIS@kneip.com> wrote in message
news:3cfb8e22_1@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.
>
>