Archives of the TeradataForum

Message Posted: Wed, 23 Nov 2011 @ 20:07:13 GMT

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

Hi Folks,

We are using DBC.QRYLOG to update our Error_log_table when ever our jobs failed by calling a macro.

but we are not getting any dta from QRYLOG tables as soon as job failed because there is bit delay in updation of QRYLOG data so we are thinking whether we can use any other table to pull info about failed sql.

or can we set a spleep time inside the macro to wait untill the QRYLOG gets updated.

plz help me are there any way to get ?

Thanks,

Ram

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