SQL> desc dba_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
SQL> You need to look more carefully. There is a column called LAST_DATE. Scott Shafer San Antonio, TX 210.581.6217 > -----Original Message----- > From: Vladimir Barac [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 3:43 AM > 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: [EMAIL PROTECTED] 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: [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).
