Hi
Try this select command select d1.*, d2.end_time from events d1, summary d2 where d1.actual_sta rt=d2.start_time and d1.node_name=d2.entity best regards, Arni Snorri Eggertsson [EMAIL PROTECTED] On Fri, Oct 04, 2002 at 01:02:52PM -0000, Petur Ey?orsson wrote: > No you dont understand me. > > Im not looking for the Status Column. Im looking for the Completed Column. > The Accutal time when the job finished. > :/ > > Kvedja/Regards > Petur Eythorsson > Taeknimadur/Technician > IBM Certified Specialist - AIX > Tivoli Storage Manager Certified Professional > Microsoft Certified System Engineer > > [EMAIL PROTECTED] > > Nyherji Hf Simi TEL: +354-569-7700 > Borgartun 37 105 Iceland > URL: http://www.nyherji.is > > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > David Stabler > Sent: 4. oktober 2002 12:28 > To: [EMAIL PROTECTED] > Subject: Re: Event Report > > > I really hate doing this...... > > >>> [EMAIL PROTECTED] 10/04/02 06:55AM >>> > > > If you do a q event * * begind f=d > > [snip] > > Status: Completed > > [snip] > > > > i can see a status there called Completed. > > > > But when i run the command select * from events > > i cant see the column completed. > > [snip] > > STATUS: Completed > > ^^^^^^^^^^^^^^^^^^^^^^^^ > > > [snip] > > Do anyone know where the column is? > > It's there. It's called STATUS. All caps may be why you're process is > missing it. Give it a try again. It's there, even in the output in > your email. > > -drs-
