DSXchange

We are working on that now. We would like Gantt chart for job run times so we could easily see overlapping jobs. Preston sort of got it started. Not sure if I can finish it. The worse part is they would not print.

There are lots of quirks to dynamic arrays. If an element is an empty string then it does not append a value. So

arrayname<1,2> = ''

is a little different than

arrayname<1,-1> = ''

even better is :

arrayname<1,Cnt> = ''

where you keep track of the elements.

You are correct dsjob works. So not ALL the command line tools fail to set errors.

You are correct. ERRORLEVEL does not work. Not sure why. All the command line tools fail to set errors.

Link does not work.

There is a job in EtlStats which loops through the log file and gets row counts. You might be able to modify it to do what you want.

DS_AUDIT might help tell you what jobs got loaded. Does not help to know if the correct DSX got loaded. Version Control has an audit file as well. VC also updates the version number of a job.

In a shell script you need to add the correct syntax to the dsjob command to set a parameter. Do a search this has been covered a lot. So if you have: ParamName=ParamValue In a file then you still need to add -param in front of this if I remember correct. MyParm=`grep jpFileName $ParamFile | head -1...

You have to come to Dallas to see me. I too old and tired to travel.

How are you starting your jobs? If from scripts then I have posted code which reset a job. It also checks to see if it needs it.

If you are doing it from a job then use DSPrepare().

We have a job which keeps as many instances of a job going as you want. Say you want to break your data stream into one per month and run 39 months. You also want to run 5 months or jobs at a time. We found that the job handle returns a status of negative about eveyr third one. Not sure why. We just...

We found that the array is not accurate. It seems that DataStage will not allow you to attach to a lot of jobs. It appears to disconnect. If the status becomes negative then we attach again. It runs really smooth now.

We use a scheduler like Control M called Zena. This helps implement faster in Zena. We have a script which can create the prm files by calling dsjob like Craig suggested.