Re: Where to find out error message?

From: Sean M. Dillon <sdillon_at_remove.this.us.oracle.com>
Date: Fri, 14 Jan 2000 08:14:42 -0500
Message-ID: <iRt=OKs7zUQ4C6GwNE2AJn+uDY=F@4ax.com>

On Fri, 14 Jan 2000 08:33:46 +0100, "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote:

>In user_jobs or dba_jobs. There is a column for that, don't remember the
>exact name now.
>
>Hth,

SQL> desc user_jobs

Name                Null?    Type
------------------  -------- ---------------
JOB                 NOT NULL NUMBER
LOG_USER            NOT NULL VARCHAR2(30)
PRIV_USER           NOT NULL VARCHAR2(30)
SCHEMA_USER         NOT NULL VARCHAR2(30)
LAST_DATE                    DATE
LAST_SEC                     VARCHAR2(8)
THIS_DATE                    DATE
THIS_SEC                     VARCHAR2(8)
NEXT_DATE           NOT NULL DATE
NEXT_SEC                     VARCHAR2(8)
TOTAL_TIME                   NUMBER
BROKEN                       VARCHAR2(1)
INTERVAL            NOT NULL VARCHAR2(200)
FAILURES                     NUMBER
WHAT                         VARCHAR2(4000)

NLS_ENV
VARCHAR2(4000)

MISC_ENV                     RAW(32)
INSTANCE                     NUMBER

so with that...

select job, failures
from user_jobs
where job = :your_job_here;

YIELDS the number of times your job has started and failed since it's last success.

Also, from the dbmsjob.sql file:

Rem (5) When dbms_job.run() or dbms_ijob.run() encounters an error, Rem the complete errorstack is dumped to a trace file and an alert Rem file. If dbms_ijob.run() was used, the number of jobs that ran Rem with errors is reported to the user.

This should give you a starting point, anyway.

--
Sean Dillon
Oracle Corporation
sdillon_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jan 14 2000 - 07:14:42 CST