RE: How long did job run?

From: <Jorma.Vuorio_at_nokia.com>
Date: Thu, 05 Sep 2002 02:58:22 -0800
Message-ID: <F001.004C83C7.20020905025822@fatcity.com>

You can find it from last_date column from that table:

SQL> alter session set nls_date_format='dd.mm.rrrr hh24:mi:ss';

SQL> select LAST_DATE from dba_jobs;

LAST_DATE
-------------------
05.09.2002 12:39:31

HTH

Jorma

-----Original Message-----
From: ext Vladimir Barac [mailto:vladob@aster.si]
Sent: 05 September, 2002 11:43
To: Multiple recipients of list ORACLE-L
Subject: How long did job run?

Hello to everyone

Is it possible to find LAST execution time of a job?

DBA_JOBS has column TOTAL_TIME, but I need something like "last time".

Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jorma.Vuorio_at_nokia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Thu Sep 05 2002 - 05:58:22 CDT