Home » RDBMS Server » Server Utilities » Some jobs stop running after some time
Some jobs stop running after some time [message #188688] Mon, 21 August 2006 03:57 Go to next message
AngelsFlyHigh
Messages: 3
Registered: August 2006
Location: Sweden
Junior Member
Hi!

I have a DB (Oracle 9.2.0.1) where we have three jobs that stops running from time to time. They are scheduled to run once every minute and they do run fine for a day or some days but then for no reason they just stop running.
I do have other jobs that are running fine all the time.
When I run DBMS_RUN then the job starts up again and run fine for a day or so, until it stops again.
The difference between the jobs that runs fine and the once that stops is the once that stops are running once every minute or once every 5 minutes. The once that are working fine are running once every day.

The only strange thing I have on this DB is one job that runs continuously.

I have tried to change job_procceses from 10 to 11 to 20 but the jobs continues to stop.

Have anyone seen this before?

(I'm new here so if this are in the wrong forum please let me know where it should be in)
Re: Some jobs stop running after some time [message #188691 is a reply to message #188688] Mon, 21 August 2006 04:06 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
When it happens again, please post the following output for the failed job:

SELECT broken, failures FROM user_jobs WHERE ...
Re: Some jobs stop running after some time [message #188728 is a reply to message #188691] Mon, 21 August 2006 05:50 Go to previous messageGo to next message
AngelsFlyHigh
Messages: 3
Registered: August 2006
Location: Sweden
Junior Member
Hi!

Sorry but its not that easy:
SQL> select job, broken, failures FROM user_jobs;

       JOB BROKEN   FAILURES
---------- ------ ----------
       121 N               0
       122 N               0


This is the complete joblist:

SQL> select job, LAST_DATE, LAST_SEC, NEXT_DATE, NEXT_SEC,BROKEN,INTERVAL, FAILURES from dba_jobs order by job;

       JOB LAST_DATE   LAST_SEC NEXT_DATE   NEXT_SEC BROKEN INTERVAL                                                                           FAILURES
---------- ----------- -------- ----------- -------- ------ -------------------------------------------------------------------------------- ----------
        51 2006-08-21  12:47:33 2006-08-21  12:48:33 N      sysdate + (1/(24*60))                                                                     0
        53 2006-08-21  04:00:05 2006-08-22  04:00:00 N      trunc(sysdate)+1+(1/24)*4                                                                 0
        61 2006-08-21  11:05:43 2006-08-21  11:06:43 N      sysdate+ (1/(24*60))                                                                      0
        62 2006-08-08  20:00:10 2006-08-22  20:00:10 N      SYSDATE+14                                                                                0
        63 2006-08-20  19:03:13 2006-08-21  19:03:13 N      sysdate+1                                                                                 0
       121 2006-08-20  19:00:39 2006-08-21  19:00:00 N      trunc(sysdate)+1+19/24                                                                    0
       122 2006-08-19  16:36:05 2006-08-19  16:38:05 N      sysdate+2/1440                                                                            0
       181                      2006-08-15  11:28:43 N      null                                                                             


The jobs that stops from time to time is 51, 61 and 122. The rest run as they should. I cant see a reason for why they stop.

Re: Some jobs stop running after some time [message #188771 is a reply to message #188728] Mon, 21 August 2006 10:34 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How long has this particular server been up without a reboot? There were some issues with the job system when servers were up for an extended period of time.
Previous Topic: CONTROL FILE
Next Topic: DATA PUMP using up UNDO! (and temp)
Goto Forum:
  


Current Time: Thu Dec 08 04:15:33 CST 2016

Total time taken to generate the page: 0.19551 seconds