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 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

>>

>> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishna Kakatur
  INET: Krishna.Kakatur_at_Sun.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).