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 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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).