Archives of the TeradataForum
Message Posted: Wed, 11 Mar 2009 @ 18:02:25 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|