| Some jobs stop running after some time [message #188688] |
Mon, 21 August 2006 03:57  |
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 #188728 is a reply to message #188691] |
Mon, 21 August 2006 05:50  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
