Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Reporting execution times
From:   Babu_Gopal

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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020