Archives of the TeradataForum

Message Posted: Tue, 23 Jun 2009 @ 11:34:12 GMT

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

Depending on the immediacy of notification you may be able to leverage access logging on the table capturing any INSERTS that occur against the table(s) in question. Then you can simply setup up a job that runs against the access log table that periodically checks (similar to a canary script) to see if there are any records in the access log table in DBC meeting this particular criteria and generate your emails accordingly.

This solution would not have the immediacy that a trigger and XSP would provide but may still offer satisfactory results.

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