DSXchange

Yes.

So... the sequence job itself had the PID failure or one of the jobs it attempted to run had the failure? For the latter, anything in that job's log?

For an intermittent error like this, something you can't reproduce, in your shoes I would involve support.

Then you leave the variable unset.

As noted earlier.

You must add it to the job... it should be one of several 'default' APT variables that every job should have so you have the option to override the default value at any time as needed.

Nope, at least not via a Job Activity stage which automatically does a "wait" making them run in a serial manner. At least that's what I recall. It would provide a gate, however, and not proceed until all are complete (assuming it is set that way) but won't affect parallel versus serial in...

Set up (or find) a Sequence job with multiple unconnected Job Activity stages. No need to actually run it but rather examine the job control code that it generates. From what I recall, you should be able to find the code where it starts all of the jobs and then issues a single DSWaitForJob function ...

"It has to be done"... what it? Can you answer my first question in the last post please? What you are needing to do is far too nebulous at the moment.

What exactly is your goal here, what do you plan on running After SQL? It's not really meant for supporting an anonymous block or items of that ilk AFAIK, if you need to do anything like that I would suggest you build a proc and then call the proc from there.

For WeekdayFromDate, it expects a Date field, and will return a numeric value. Specifically when it says the "day number of the week" is returned it means a 1 for Sunday (2 for Monday, etc) because Sunday is the first day of the week by default. You can override that if desired but I gene...

And that looks more like a PX error as seen here but for all I know it is one that could be thrown by a Server job as well.

The Technote wrote:Note: Other stages may see the same warning occur. Please contact IBM Technical Support for further assistance.

You should be able to copy and paste it here as people do that all the time, not sure why that wouldn't be working for you. Sorry.

Also, can you describe your job design? Is it your basic bare bones SRC -> TRANSFORMER -> TGT kind of job or something more complex?

First make sure you understand that a multi-instance job is still a single job that is allowed to run multiple copies of itself at the same time. Meaning, there is still only a single job log and all of the instance runs are crammed in there together. The Monitor makes them look like they might be c...

And?

:idea: Just as an FYI, there's no need to 'Reply with quote' unless there's really a need to actual quote the message you are replying to and that generally isn't the case. I removed the quoted text from your post, just because I'm anal like that. The Reply to topic option is the weapon of choice in...