Re: Job queue question

Hello Georg,

SQL> desc dba_jobs_running

 Name                                                        Null?    Type
 ----------------------------------------------------------- --------
-----------
 SID                                                                  NUMBER
 JOB                                                                  NUMBER
 FAILURES                                                             NUMBER
 LAST_DATE                                                            DATE
 LAST_SEC                                                            
VARCHAR2(8)
 THIS_DATE                                                            DATE
 THIS_SEC                                                            
VARCHAR2(8)
 INSTANCE                                                             NUMBER

should help.

Please don't crosspost.

Martin

Georg Scholz wrote:
>
> Hello,
>
> We are using Oracle 8.1.7
>
> I want to schedule a job ONCE using DBMS_JOB.SUBMIT(). After the job is
> complete, I want to know how long it was running.
>
> Problem is, the job disappears from the Job List (USER_JOBS) once it is
> complete. So there seems to be no way to get the job's run time !?
>
> I looked in the manuals, but didn't find a solution .
>
> Does anyone know how to solve this?
>
> Thanks in advance for any hint
>
> Georg Scholz
Received on Thu Jun 13 2002 - 02:33:26 CDT