DSXchange

DSExecute or ExecSH are the 2 most popular.

Ken

We agree with you.

My script posted does a reset if needed before running a job. The problem here is the jobs still say they are running because the DataStage server crashed hard. You have to clean up resources or compile all your jobs. I am not sure there is a way around it.

I have never tried DwNav with version 4. I am not sure it will work. The problem maybe when you register DwNav it cannot read the registry because it is not the same. There is a way around this. There should be a procedure in DwNav.mdb to manually update the links. I link to DSProjects and other tab...

I have never tried DwNav with version 4. I am not sure it will work. The problem maybe when you register DwNav it cannot read the registry because it is not the same. There is a way around this. There should be a procedure in DwNav.mdb to manually update the links. I link to DSProjects and other tab...

That is not exactly what I thought they asked for. I think they wanted to reset all jobs. My shell script does reset a job if it needs it before running it. Sequences do a similar thing.

You can recompile all your jobs fairly quickly. I am not sure I posted a routine but it would not be hard to write. Resetting jobs is not hard but sometimes slower than compiling.

Well said. Ignore him Ray. We think you are awesome. Thanks Ken and many others as well. I need a break too Ken.

If Doc Tool exists then we could post the SQL to run in the dooc_tool.mdb Access table. DwNav might work against the doc_tool.mdb. You can download it from my web site. It can document the whole project in seconds. It creates html documents one per job. It creates a crossref sorted by table name dis...

Here it is http://www.duke-consulting.com/Download ... incent.zip

Not sure if you ever got this.

Ray made a joke. Craig pay attention.

Download EtlStats from my tips page. It has lots of examples. Most of the jobs have nothing but job control so the syntax is the same as in a routine. The SDK that comes with DataStage has lots of examples. Ask when you see something you do not understand.

scriptfile mkdir.sh ftp servername $ ftpmkdir $1 Does not look right. What is the $ on line 2. In your first post you said this was the command: echo "\$ ftpmkdir" | ftp servername If you can pipe into ftp then do the whole thing that way. ftp $1 <<! user password mkdir $2 bye !

.netrc and macros can be disabled on the target server. If any shell script works at the command line and not within DataStage DSExecute or ExecSH is either a permissions problem or a environment variable issue. All DataStage jobs run as phantoms and do not execute the .profile so your UNIX environm...

If people want to send me a DSX file where they have dumped the log to a table then please email it to me. I will add it to my links page.