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 VÃlez 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).
