Re: Problem with jobs
Have you checked DBA_JOBS for the last/next execution times? Is the job broken? Please check DBA_JOBS. Jared On Mon, 2004-01-26 at 06:04, Mauricio Vlez wrote: Hi, This is the situation: 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 databases and worked on the first one but not on the second one. If I manually execute this:(On the database that have the problem): Exec dbms_job.run(job_number); Then the job is successful executed (without any error) and is programmed to the next interval but after that its not executed any more. And It doesnt appear broken (Its like the queue process were not working). I know all jobs are not executed because the column last_date on dba_jobs its not updated on any job (so next_date column its not updated) and the procedure of each job are not doing what they must do. Its happens since one week ago and before that they were working well. When I submit the Job I issued commit and I dont receive any error message So the Jobs doesnt appear broken (Its like the queue process were not working) But the initialization parameter are job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file So I repeat, the jobs were working well until one week ago, and I havent change nothing special on database. the view dba_job_running appear empty all the time. I removed all jobs and I recreated them again and it didnt resolve the problem. Im not using Oracle Enterprise Management, so I cant see diagnostic error messages and in the alert file it doesnt appear nothing related with the jobs. So early at morning I have to run the jobs manually Im thinking on shutdown down database but I want It to be the last option. I hope you can help me Thanks Mauricio __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Problem with jobs
Mauricio, Check the Oracle version. We had similar problems with 8.1.7.2. They got disappeared after we upgraded to 8.1.7.4 -- Thanks, Krishna ~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~ Jared Still wrote: Have you checked DBA_JOBS for the last/next execution times? Is the job broken? Please check DBA_JOBS. Jared On Mon, 2004-01-26 at 06:04, Mauricio Vlez wrote: Hi, This is the situation: 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 databases and worked on the first one but not on the second one. If I manually execute this:(On the database that have the problem): Exec dbms_job.run(job_number); Then the job is successful executed (without any error) and is programmed to the next interval but after that its not executed any more. And It doesnt appear broken (Its like the queue process were not working). I know all jobs are not executed because the column last_date on dba_jobs its not updated on any job (so next_date column its not updated) and the procedure of each job are not doing what they must do. Its happens since one week ago and before that they were working well. When I submit the Job I issued commit and I dont receive any error message So the Jobs doesnt appear broken (Its like the queue process were not working) But the initialization parameter are job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file So I repeat, the jobs were working well until one week ago, and I havent change nothing special on database. the view dba_job_running appear empty all the time. I removed all jobs and I recreated them again and it didnt resolve the problem. Im not using Oracle Enterprise Management, so I cant see diagnostic error messages and in the alert file it doesnt appear nothing related with the jobs. So early at morning I have to run the jobs manually Im thinking on shutdown down database but I want It to be the last option. I hope you can help me Thanks Mauricio -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur 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).
Problem with jobs
Hi, This is the situation: 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 databases and worked on thefirst one but not on the second one. If I manually execute this:(On the database that have the problem): Exec dbms_job.run(job_number); Then the job is successful executed (without any error) and is programmed to the next interval but after that its not executed any more. And It doesnt appear broken (Its like the queue process were not working). I know all jobs are not executed because the column last_date on dba_jobs its not updated on any job (so next_date column its not updated) and the procedure of each job are not doing what they must do. Its happens since one week ago and before that they were working well. When I submit the Job I issued commit and I dont receive any error message So the Jobs doesnt appear broken (Its like the queue process were not working) But the initialization parameter are job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file So I repeat, the jobs were working well until one week ago, and I havent change nothing special on database. the view dba_job_running appear empty all the time. I removed all jobs and I recreated them again and it didnt resolve the problem. Im not using Oracle Enterprise Management, so I cant see diagnostic error messages and in the alert file it doesnt appear nothing related with the jobs. So early at morning I have to run the jobs manually Im thinking on shutdown down database but I want It to be the last option. I hope you can help me Thanks Mauricio Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!