Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 08:54:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

I need to pickup the information like below.

I have a table called A which has following Collumns.

     Id   SqlType   Date/Time of Execution   Elapsed Time   No.of.Rows Return

I have set of queries in the table Called B which has to be executed one by one and it needs to Capture the information like

     Id   SqlType   Date/Time of Execution   Completion Time      No.of.Rows Return

     1    Query1    12/12/04    10:01:05     12/12/04  10:30:04   1200
     2    Query2

How will get these information? Or Is there any systable where I can get it

Early Response is appreciated.

Thanks & Warm Regards

	<Prev	Next>		<<First	<Prev	Next>	Last>>