DSXchange

So, by 'get aborted also' you actually mean 'do not run', yes? And if you truly want them to be independent, make them so - use two separate Sequence jobs.

Hmmm... if that's the default then perhaps using "-R" would make it do what you want. Note that's an upper-case R rather then the lower-case one you were using originally.

The link was just to show that was a known issue with (apparently) no solution. Can't answer the Monitor question and have no way to research it at the moment, I'm afraid.

But, the other problem which is raised is: my sequence will abort as soon as it reached the aborted job stage. Why is that? It should just restart the sequence from that point, reset the aborted job and go. What kind of 'abort' are we talking about here? Can you post the actual errors involved? :?

Perhaps you should consider not using the "-r" option? That is, after all, what it does.

A Sequence job could run the first job and then use the csv file in the Start/End Loop stages to run the second job, once for each record in the file. That or perhaps UtilityRunJob() could be leveraged.

At some point I stop asking the 'why' part.

Same as you would anywhere else. It's your choice on exactly where you issue the appropriate SQL - assuming you have the grants and a really good reason, of course. So perhaps as completely separate steps controlled by a Sequence job: disable, run job, enable... or before/after job... or in the Open...

a) This doesn't match what is in your Subject. b) How can something be greater than itself?

OK, they did go to 7.5.3 before moving to 8.x, probably worth asking your support provider if it's known and fixed in a later release.

Post the actual error message.

Then it sounds bug-like to me. What exact 7.x version are you running?

That same search would reveal possible solutions, if you've bothered to do that, that is.

Yes, it's too large, which a search for "could not map table file" should reveal.

Not quite sure why the version would matter when their edition doesn't support it in any fashion.