Re: dbms_job issue.

> Avnish.Rastogi_at_providence.org wrote:
>
> Hello List, I am running into weird dbms_job issue. I have a dbms_job
> to collect perfstat every 1 hour , job was running fine for last 8-9
> months without any issue. For last 3 days job is stopping every night
> around 2 AM. I am not seeing any trace file, any logs in alert file.
> Any idea what is cuasing this. Below is the output from dba_jobs. We
> are on 9202 AIX 5L.
>
>
> JOB LAST_DATE NEXT_DATE THIS_DATE
> B FAILURES TOTAL_TIME
> ---------- ------------------ ------------------ ------------------ -
> ---------- ----------
> 45 18-SEP-03 02:01:02 18-SEP-03 03:00:00
> N 0 175
>

The big nuisance with jobs is that they leave you in the dark when they fail. You may find some of the stuff here interesting to diagnose :

    http://www.oriole.com/aunt_2001_0.html (March letter)

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).