Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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