How to get an Alert Message when a File is being Written
Moderators: chulett, rschirm, roy
How to get an Alert Message when a File is being Written
I have a File to Capture rejected records....Is it Possible to get an alert everytime this File is written to...? If so how..thanks....(without using job sequence)
Yes, it is possible (perhaps even easy) to do something like this. The question is what sort of an alert message? You can put a transform stage in the stream that writes to this reject file, and add a specific call to write a log message (the sdk routine "UtilityWarningToLog" will do that). Or you can put a before-stage or after-stage call in that transform to issue just one call to a program, or script, or routine of your choice.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If you mark the constraint as a 'Reject Row' you'll automatically get an 'alert' (read 'warning') logged with the total row count rejected if anything goes down it. As noted, the answer is heavily dependant on what kind of 'alert' you want.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers