Re: Job queue question

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 23 May 2002 23:31:09 GMT
Message-ID: <3CED7BBC.19C3607@exesolutions.com>

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

Have the job, have all jobs for that matter, insert their run time to a log table so that you can later run statistics.

Daniel Morgan Received on Thu May 23 2002 - 18:31:09 CDT