Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Mar 2009 @ 18:02:25 GMT


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


Subj:   Timing a Long running Query
 
From:   Ronald Montemayor

Is there a way to know how long the query has been running?

We can of course look at pmon to check this, but we would like to automate this and integrate to our monitoring system, and send and alert.

Example is, A specific QUERY from certain application/user should only take less 15mins, if it exceeds that, we want to get an alert right away.

We are looking for "DURING" alert - while the query is still running. Not after the fact, which we can really find this by looking at DBQL.

Thanks for your help.



     
  <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