DSXchange

Exactly - what changed? And as Ray would note, "nothing" is not the correct answer. And if you know it wasn't the job...

The simple answer is 'yes' as there's nothing about the shared container itself that precludes you from adding one multiple times to a job. It's all going to depend on what the container... contains.

".ETL_ERROR_FILE_STAGING" is indeed an invalid table name. Either ensure the owner schema is provided or get rid of the dot.

I am wondering what could be the reason for this unique constraint violation. So are we, and it's not really a question we can answer for you other than to state what Ray did. The routine has no clue if some other process has already issued a given number or not, it just assures that it only hands ...

Your shell script needs to prepare the environment was well as run jobs. You would do this by 'sourcing' the dsenv file: cd $DSHOME . ./dsenv The first line would need to change if $DSHOME isn't set in the 'cronacle' user's .profile. Not sure why 'sudo' would be involved unless that is a Cronacle re...

Resolved?

Also note that 'reset' does not run, it just resets. You need to invoke dsjob twice if you want to 'reset then run' a job.

Ok. Please provide as much detail as you can about how you are using the stage... as a Source? Target? What does the SP do? Does it return data or just a status? Etc. etc. etc.

Just like you would for any other database - create a link from the transformer feeding the ODBC stage to a Sequential File. Then either mark it as a Reject link or use a constraint to get just what you want sent down it. An official Reject link will take any row that was not accepted by all preceed...

Not much information to go on. Let's start with this - what database?

The sytax is detailed in the Server Job Designer's Guide in the Command Line Interface chapter - have you looked there?

Set -warn to 0 if you want unlimited warnings. We use 5 but a single warning is considered a failure here. Don't forget the -wait or -jobstatus options as well. And you may want to sleep a few seconds between the two commands.

The only way to get 'duplicates' from a Reference link is if the stage used to do it is ODBC or the UV stage. What you got?

Sure you can - with the Director. Regardless, doesn't change my advice.

Emulate a Job Activity stage - Reset if required then run. Leave off the second 'reset', you can do that manually if desired but the job will rerun without you having to do that.