RE: Jobs are not working

2004-01-23 Thread 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 PMTo: Multiple recipients of list 
ORACLE-LSubject: 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 VXlezSent: Friday, January 23, 2004 11:04 
AMTo: Multiple recipients of list ORACLE-LSubject: 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.orafileMauricio "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 itOne database can 
  execute jobs normally, but the other one not execute anyjob.I 
  proved submitting the same procedure to both database and worked on 
  thefirst one but not on the second one.How can I resolve 
  this?Mauricio VélezDo you Yahoo!?Yahoo! 
  SiteBuilder - Free web site building tool. Try 
  it!


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

RE: Jobs are not working

2004-01-23 Thread Johnson, John R. (Oracle DBA) 



Do you 
have 4 jobs currently running? Maybe you need more 
processes.

John

  -Original Message-From: Mauricio "Vélez 
  [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 
  11:04 AMTo: Multiple recipients of list ORACLE-LSubject: 
  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.orafileMauricio "Vélez" 
<[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>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 itOne database can 
execute jobs normally, but the other one not execute anyjob.I proved 
submitting the same procedure to both database and worked on thefirst 
one but not on the second one.How can I resolve 
this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuilder 
- Free web site building tool. Try 
  it!
  
  
  Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try 
  it!