RE: Jobs are not working

[Johnson, John R. (Oracle DBA)]

Title: Message

Mauricio:

Is job_queue_processes set to a value higher than 0?

Did you commit after submitting the job?

 

John R. Johnson
Anheuser-Busch Companies
Server Technology and DBA Services
Oracle Database Administration 
 

 -----Original Message-----
From: Michael Fontana [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Jobs are not working

Mauricio:

 

Define the exact symptoms of your problem.

 

For example:

 

How are the jobs being submitted?

 

Are you getting an error message upon submission?

 

How do you know  they're not running?

 

Have you queries dba_jobs_running?

 

Please respond with any diagnostic error messages, or any other documentation you wish to provide to give us more detail.

 

 

Michael Fontana

Sr. DBA

NTT/Verio

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio VXlez
Sent: Friday, January 23, 2004 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Jobs are not working

I issued commit and

job_queue_processes = 4

job_queue_interval   = 10

 

in init_SID.ora file

 

so I don't know why the jobs are not working

 

regards,

Mauricio Vélez

 

[EMAIL PROTECTED] wrote:

A COMMIT is required after "submitting" the job.

job_queue_processes = 4 <=== Must be greater than zero in init_SID.ora
file





Mauricio "Vélez"
<[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>
hoo.com> cc:
Sent by: Subject: Jobs are not working
[EMAIL PROTECTED]
.com


01/23/2004 08:29
AM
Please respond to
ORACLE-L






Hello everybody= "urn:schemas-microsoft-com:office:office" />

I'm woriking on NT and there are two 8i databases on it
One database can execute jobs normally, but the other one not execute any
job.
I proved submitting the same procedure to both database and worked on the
first one but not on the second one.

How can I resolve this?

Mauricio Vélez


Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!