DSSendMail only upon the records reject

mikegohl · Post by **mikegohl** » Tue Apr 28, 2009 3:49 pm

I use that code in a afterjob subroutine of the job that creates the reject file, not in the sequence job.

chulett · Post by **chulett** » Tue Apr 28, 2009 10:00 pm

dsedi wrote:Can I use the DSGetLinkInfo in the Job activity Trigger expression?

In other words, nope.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 29, 2009 12:53 am

dsedi wrote:Can I use the DSGetLinkInfo in the Job activity Trigger expression?

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 · Post by **dsedi** » Thu Apr 30, 2009 8:38 am

Thanks very much Mike,Bob ,chulett,ray for stopping by..its truly appreciated.
I am marking this as Resolved.

mikegohl · Post by **mikegohl** » Thu Apr 30, 2009 8:43 am

Just wonder which way you implemented the solution?

dsedi · Post by **dsedi** » Fri May 01, 2009 1:14 pm

mikegohl wrote:Just wonder which way you implemented the solution?

Mike,
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.