DSXchange

What buffering option do you have enabled in the job? Also, what exactly are "input transfer stages"... transformers?

I don't "do" SQL Server, so don't know what it expects. How would you do this outside of DataStage? What syntax would you use or what format would the date need to be in to allow it to insert successfully into that field?

Anyone who works with SQL Server care to chime in?

What flavor of Windows is your server running? I vaguely recall that not all versions of the "at" scheduler support the "every" option...

Parallel Job Advanced Developer's Guide, Chapter 6: Environment Variables

Got your email. When you first posted this to the PX forum, I moved it to the General forum as that was the appropriate place for a question like this. Deleting it from there and reposting it in the PX forum wasn't the right thing, so... Unlocked and moved back to the General forum. Hopefully now, a...

I was wondering the same thing, but confused by the assertion that it works with the timestamps from the command line.

That was my first question as well - why are you logging what must be an enormous number of log messages? If these are warnings from the job, fix it so they are no longer an issue, if at all possible.

First observation, you don't do both -wait and -jobstatus, you should use one or the other. Both cause it to wait, the difference is what status is returned. I noticed, we are passing timestamp as a param and that is causing issue. So, what makes you think the timestamp parameter is the issue? I pas...

You've already posted this once, no need to do so again.

When you Reset the aborted job, is there an entry added to the log that says "From previous run..."? If so, post the contents.

Looking for the exact syntax of the trigger expressions you are using out of Job2.

Those multiple jobs all came from the same large dsx file, yes? Can you not open that file and find line number 1334814?

"restructures"? As in all is OK with simultaneous use and this topic is Resolved now?

epitts88 wrote:Again, the formatting will have gone so see description.

The "code" tags preserve whitespace and thus the formatting of your ASCII art. See?

That would be what is called a "vertical pivot", also known as rows to columns. So... pivot stage.