RE: Jobs are not working
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!
RE: Jobs are not working
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
Title: Message 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] 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!
Re: Jobs are not working
On 01/23/2004 11:29:32 AM, Mauricio V?lez wrote: How can I resolve this? By reading the administrators guide. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: Jobs are not working
Can you execute the "what" column's contents in SQL*PLus. Sometimes table permissions get in the way. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:56 PMTo: [EMAIL PROTECTED]Cc: Goulet, DickSubject: RE: Jobs are not working The Jobs are not broken I haven't resolve this yet, all jobs work fine on one database but on the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" <[EMAIL PROTECTED]> wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: 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! SiteBuild! ! er - Free web site building tool. Try it! Do 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
The Jobs are not broken I haven't resolve this yet, all jobs work fine on one database but on the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" <[EMAIL PROTECTED]> wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 233, 2004 12:04 PMTo: 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! SiteBuild! er - Free web site building tool. Try it! Do 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
Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: 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! SiteBuild! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
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!
Jobs are not working
Hello everybody Im 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!