DSSendMail only upon the records reject
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't see why not, but it would need to be part of an expression that could be interpreted as true/false to control notification properly. Therefore it could only be invoked indirectly (through a Routine) because the job handle argument can only be managed by DSAttachJob() and DSDetachJob() - DSJ.ME would pertain to the job sequence itself. Then there is the problem of the DEFFUN declaration. All in all, an upstream Routine activity would be a better way to capture the row count.dsedi wrote:Can I use the DSGetLinkInfo in the Job activity Trigger expression?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Mike,mikegohl wrote:Just wonder which way you implemented the solution?
Apologies for the delay..
In the sequencer, after the Job activity (for reject file creation)we have the Exec command activity. Which will execute the wc -l and the trigger expression will have Field(trim( Execute_Command_4.$CommandOutput) ,' ',1) >1 (because my error file will have header record always) which will control the Notification
I have tried the DSGetLinkInfo but no luck.
But I'll keep that issue as a separate post with a meaningful subject.
Once again.. Thanks everyone for your suggestions.