DSXchange

So, not a Server job as marked. And Oracle 11g, yes? I doubt it is supported but may work with a 10g (or 9i) client. [shrug] Best to ask support.

No idea what to try next. Worst case, write a routine to use DSExecute( ) and run with a Routine Activity stage instead.

I don't think "@" (no echo) will work as the command. With everything parameterized it typically is a "shell" command so perhaps "cmd" would work for Windows there?

I must be thick today. "Status message" meaning you can see in the job's log that the email was sent but you didn't receive it? Any problem of that nature needs to be brought to the attention of your SysAdmins, have them check / confirm the sendmail setup on that server. DataStage doesn't do anythi...

I for one have no idea what you mean by "UNIX box path but not into my mail inbox". Can you clarify your issue, please?

Could you clarify what "cleaned up the DataStage home directory" means, please?

Is that "empty" file static? You could build a Sequence job to check the output of the processing job (DSGetLinkInfo) and then substitute in a stashed copy of this empty file for the "real" one.

You can only use DSJ.ME for the job handle, the other two will need to be the actual stage and link names. And you don't use any percent signs, those are strictly for the template not what you pass.

Could be... something else to check on with my elusive SA friends.

Very little that goes on here is a waste of time. This is all good learning information for anyone with the same question or whom stumbles over this, so no worries.

WoMaWil wrote:and even in OpenSource you find Cattle.

Kettle, actually. You find cattle in OpenRange.

Is the HP-UX process table filling/full, preventing allocation of any more process IDs (pids)? I don't believe so, but I'll have the SAs check the logs tomorrow. The server was pretty quiet other than these jobs as it allegedly dedicated to the QA group. From what I recall, it was running about 75%...

Not sure the PHantom directory was the culprit here as, in checking and clearing other projects, I'm finding ones with multiple thousands of entries, including the Big Winner with 14040. We'll see.

Have something odd going on, with errors and situations going on I've never seen before. These are issues with old jobs on a secondary QA server, jobs that run fine in 3 other environments but haven't been run on this particular box for about a month. And no, I'm not aware of anything that may have ...

Probably wasting your time but the results will be good information, I suppose. While you are doing that, you should open a case with your official support provider and see if this is a known bug in the latest release.