> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
