DSXchange

Why include the server name? It's not listed in the syntax for me when I check it on my server: $ dsjob -import Invalid arguments: dsjob -import <project> DSXfile [ [-OVERWRITE] -JOB[S] * | jobname ...] | [-LIST] If you want everything imported, it looks like all you need to supply is the project an...

denzilsyb wrote:In ValidateJob, I have the trigger set to "OK"

You might want to explain exactly what this means. Do you mean you have the trigger set to "OK- (Conditional)" or some sort of Custom trigger where you wrote the condition?

So, you have no idea what the error message is? Have you tried Resetting the job via the Director? Sometimes that will get you some additional information labelled as "From previous run".

In layman's terms it should mean that it would work as long as it is issued from inside a 'job', not directly from the command line. So, a piece of job control code or a routine (before job, let's say) could use DSExecute to issue the command and then it would work. Only way I can see accomplish wha...

shiva459 wrote:I am not sure how the restartability is related to calling my routine activity.

Check this post,it should help explain how they relate.

That's why you need to make Sequence 1's return code not fine when any of the jobs have issues. You must have missed this in Ray's post: all warning exits go through an Any sequencer to the LogWarn routine By writing a warning to the sequences log when a job fails, your trigger will pick up on that ...

Ah. I guess the question really should have centered around the 'start' command, but I have since looked at its help information and see how the /wait and /b parameters play here.

This shouldn't be a problem and doesn't involve a need for different templates. Not being totally sure what you mean by "job sets", this answer may be a little off. I'm also not sure what you meant by "I am not planning to change the From/To section in the JobNotificationActivity". If you need to se...

Nope. Same modules.... well, unless you go way back and consider Version Control a new module.

Good advice, but Sonia is on an NT server.

That's true. If you want to import more than just executables, you need to do it from the Client. Ascential has talked about improving the server side support for things like this, and it may show up in future versions - but is not available now.

I use SORT STAGE to sort the sequential file that is generated by my job. Just this stage itself takes 1 to 2 minutes. I did not get any improvement in performance even after giving a temporary directory (not sure whether it does improve performance in the first place). The temporary directory isn'...

Check the syntax for the dsjob command. There is a -import option you can use for this.

That's true - forgot about that one. Open up your transformer and right-click in the derivation. You'll find something called Derivation Substitution that should get you what you need.

Available in 7.0 and up.

Well, that's just a plain old Oracle syntax error. First try putting the single quotes back around the parameter marker inside the TO_DATE function and see if that fixes it. If that doesn't do it... Take your query and paste it into your favorite query tool - TOAD, SQL*Plus, whatever - and replace t...