Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Emailing based on table activity
 
From:   Rob Paller

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023