Archives of the TeradataForum

Message Posted: Fri, 07 Aug 2004 @ 01:14:40 GMT

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

Use a stored procedure to execute the sql statements, you can load the sql statements into a cursor and execute them sequentially. Create a logging table, log the sql start time before you execute your statement, then update the log row after statement execution. If you get really creative you can log resource utilization stats as well.

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