DSXchange

You can check for "job interim status" at that point to know if the job is going to finish OK or abort after it completes the after job section... i.e. if there was a problem with the job itself.

Reply to topic is your friend! Well, my friend technically. There was no need to quote the entire original post just to add your one line.

Ok, no worries. Can you clarify if you edited that text file to add the %file% attachment token or is that 'out of the box' on your system?

First off, there's no need to send me a private message while we're discussing your issue. Anyone here can help and I'll come back to the conversation when I have the time. Be patient. I'd also like to note that the amount of help I can provide is limited as I have no access to DataStage in any fash...

What exactly is the "same problem" that you are having? Best to start your own post for something like this with all of your details spelled out...

Let me be more precise... are you using the full path to the attachment file in the Notification Activity stage?

Full path?

Yup... a Best Practice.

Those should be in your dsenv file along with everything else... perhaps it was how you 'called' dsenv?
Like so when inside DSHOME?

Wingnut wrote:so it looks like I can run this directly because my user id knows more than the cron/at daemon does.

That is very true and all about your profile. Source the dsenv file in your script so any user that runs it knows all that needs to be known.

Perhaps this will help?

Not available via dsjob. You can, however, execute a dssh query of DS_JOBS from the command line for NAME where CATEGORY = 'YourFolder'.

To be honest, I'm a little lost. What is actually inside your loop? I understand it is an 'FTP session' but how it is implemented, via a single Execute Command stage? And this Cleanup On Failure, that's a part of the FTP processing and not part of DataStage, correct? Also trying to understand why ki...

An exact search for that error comes up empty here, so not sure what other posts you are referring to. All I could find out in the wild is this reference entry that seems to confirm it is about your inability to map it: http://www-01.ibm.com/support/knowledgecenter/#!/SSZJPZ_8.7.0/com.ibm.swg.im.iis...

Moved to the proper forum... please clarify for us your DataStage version number and server OS platform, I had to guess.