| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: DBMS_OUTPUT display while processing?
On Mon, 09 Aug 1999 22:31:51 +0800, Connor McDonald
<connor_mcdonald_at_yahoo.com> wrote:
>Chris Hamilton wrote:
>> I had a similar problem. I created a series of "Job Control" tables:
>>
>> JC_JOBS -- one row per batch job per run.
>> JC_TASKS -- one row per task of each job.
>> JC_EVENTS -- one row per event of each task.
>>
>> And a package called JOB_CONTROL.
>>
>> My batch PL/SQL programs make calls to JOB_CONTROL, which in turn
>> populates the tables with status rows, which have timestamps and
>> descriptions of the tasks. You can then track the ongoing status of
>> jobs, seeing where it is and how long it took to get to that point.
>> Also tracked are parameters passed to the various events (procedures),
>> etc.
>>
>> Very handy.
>>
>> Chris
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Christopher Hamilton
>> Oracle DBA -- Wall Street Sports
>> chris_at_wallstreetsports.com
>> http://www.wallstreetsports.com/
>
>The only downside being that you need to commit to see that status from
>a different session...
Yes, true. For us, though that's okay, due to the nature of our batch jobs. Each "event" is pretty much something that should be committed anyway.
Your mileage may vary, of course.
Chris
 |
 |