DSXchange

Contact your official support provider.

S1 and S2 run six hours apart... but I suppose this 'S0' could sleep that long between them.

If you want to go 'Execute Command' then that would be the operating system command I mentioned - dsjob. One of the many options it supports is -jobinfo which will give you (amongst other things) the status from the last run. You'd need to parse that out from the output using something like 'grep' w...

As I noted first off, it would help to know which number you were actually after.

Well... you will actually have to run Sequence 2 if you want the check of Sequence 1 to be part of it. You may want to consider scheduling a script that makes a call to "dsjob -jobinfo" so it can check to see what happened with Seq1 which then only runs Seq2 (again with dsjob) if the first...

Not sure how that helps, they need to see how a job parameter is being resolved to see if it retains its quotes or not. Perhaps a union with a simple sql to unconditionally pull a single record so you can get information into the Peek stage?

D'oh. Dang PX job.

Here I would take a delimited string and then Convert the delimiters to Value Marks:
Pretty dang sure it should be Value Marks, can't test this right now.

Set up a stage variable with that list in a dynamic array via its Initial Value. Then you could use a function like Locate() to search the list. You could do something similar with Index() as long as you avoid a substring match, typically handled by the proper use of delimiters.

Hard to say but I doubt it. You need .Net for the client and multiple versions don't conflict with each other, from what I've read.

First thing I'd try is to Unschedule the job and then Add it back to the scheduler. Kind of like a reboot.

Hmmm... there are tons of examples out there on how to write ftp scripts. Seems to me one consideration would be secure versus non-secure transfers - will you be doing one or the other or a mixture of both. The non-secure ones will be pretty straight-forward, requiring a userid and password while th...

OK. What does the Peek stage show?

Any chance that 'out of range input data' simply means your source data was longer than 100 bytes/characters? A varchar2(200) won't always fit in a varchar(100) without some help.