Page 2 of 2
Posted: Tue Apr 28, 2009 3:49 pm
by mikegohl
I use that code in a afterjob subroutine of the job that creates the reject file, not in the sequence job.
Posted: Tue Apr 28, 2009 10:00 pm
by chulett
dsedi wrote:Can I use the DSGetLinkInfo in the Job activity Trigger expression?
In other words, nope.
Posted: Wed Apr 29, 2009 12:53 am
by ray.wurlod
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.
Posted: Thu Apr 30, 2009 8:38 am
by dsedi
Thanks very much Mike,Bob ,chulett,ray for stopping by..its truly appreciated.
I am marking this as Resolved.
Posted: Thu Apr 30, 2009 8:43 am
by mikegohl
Just wonder which way you implemented the solution?
Posted: Fri May 01, 2009 1:14 pm
by dsedi
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.