Archives of the TeradataForum

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

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

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>>