DSXchange

Skip that step.

There's no such option as there's no need to compile aborted jobs. You need to Reset any aborted jobs, not recompile them. That's why there is a 'Reset if needed then run' option in Sequence jobs and why there is a reset option available from the dsjob command. If by 'Job Scheduler' you mean via the...

Ray has shown you where you need to be. Run the commands as listed.

Glad we could amuse you, Ken. Point taken on the 8.x repository and something I'd been wondering about but didn't want to muddy the waters with quite yet. If all this communication is service based, that probably adds a little 'lag' that wasn't there before, let alone if the repository can now be 'r...

How many jobs are you running simultaneously? And since you did not include the full text of your log messages - what times were logged for steps #3 and #4?

Oh, and what he said.

Sequence jobs pass their warning limit down to any child jobs - as long as you use the Job Activity stage to run the child jobs. Start the Sequence with a warning limit of 1 and all jobs will use that same limit.

Or just fix your exception handling.

Please define exactly what you mean by "taking longer time to start".

There's no option you are missing. There's nothing magical about a Sequence job that would make the jobs it runs run slower. What you are probably seeing is a performance hit from running multiple jobs at the same time, rather than singleton runs outside of the Sequence job's control. Any chance of ...

Search the forums, this has been asked and answered quite a number of times.

How many times are we going to go 'round and 'round here? How many times have we seen this routine and trotted out very similar advice over and over? [sigh] Of course this can be used After Job. Yes, there is only one input argument. So? Be creative - everyone passes multiple arguments there by sup...

I should have been more specific - I don't have issues of this nature because I don't use the "problematic" stages like the Link Collector. I do as Ken suggests - separate output files and a post-processing concatenation - this is quick, easy to implement and problem free.

"It isn't provided from the server"? In what sense? If you want to import the metadata, then you will need to setup an ODBC connection to your Oracle database, as that is what it uses. However, there's no requirement that you do this step, it just... helps... as it gives you something to load into ...

What did you select from dual? You either need to select data appropriate to use in the stage or something you ignore. We select '1' from dual and then ignore that in the Transformer that sits between the two stages, instead creating and populating columns for consumption by the procedure being cal...

Partition your data properly to ensure your parallel streams aren't trying to update the same data.

The Stored Procedure stage when set to 'Oracle' will use the Oracle client on your DataStage server, not ODBC. This also implies you must have configured DataStage for Oracle and be able to use the 'OCI' stages.

Have you? Can you?