Re: Trigger and Job (DDL)

Hi,

thank you very much for this idea!

So far it sounds good to me, and if I find no other event-triggered solution I'm going this way, but I'm a little bit concerend about having a job running doing mostly nothing else then using resources (CPU etc....although it would be not that much, but if it is not necessary...)

thanx a lot for your hint
flo
,-)

"G Quesnel" <dbaguy_ott_at_yahoo.com> schrieb im Newsbeitrag news:1155232954.805321.176640_at_m79g2000cwm.googlegroups.com...
> Just a different approach ...
> How about inserting a record in a table on insert, with a timestamp,
> identifying the row that was inserted and requires validation. Your
> validation process could then be a job, that runs every x minutes,
> selecting records that are older then 20 seconds, and firing up an
> email if some condition is met. It could end by deleting processed
> records.
> You would not even need this extra record/table if the inserted row had
> a "insert timestamp".
>
Received on Thu Aug 10 2006 - 13:11:37 CDT