DSXchange

This is straight out our script to compile jobs.

Does this directory exist /home/staff/tlam/KimD/Jobs? It is trying to create /20070829 below this. The user running the job needs to be able to this directory.

Most start with DS_ or RT_. Why do you need this information? What are you trying to do?

Follow the link on my signature to my tips page to download the best practices document Ernie was talking about.

By the way remote shell is how this 2 machines talk to each other. Remote shell is a UNIX term for rsh or rexec commands. There are similar commands for DOS or Windows servers.

Do you have a config file where nodes are on different servers? If so then you need a way or command to talk to this other machine. You are trying to setup a grid but it is not properly setup.

You can design and build sequences at a lightening rate. So it is not a lot of work to move to sequences. The restartability is better in custom batch jobs if done correctly. The restartability in Control M and some other products is even better but the level of effort to put jobs into a separate pr...

Your ROI is not worth the LOE. The benefit is not worth the work to build this.

I am sure it is possible. I have not done it but I know people who have got it to work.

Ray's routine definitely shows the structure of DS_METADATA. The issue is getting the metadata to match from a PX job in DS_JOBOBJECTS. This will have to be done in job control or a routine in BASIC. There is a string you can search for with FINDSTR to find the start of where columns are stored. You...

We do all this in a shell script. Works fine.

What is the reason to not use dsjob? I think source code exists for dsjob.c on the installation CD.

We took the DataStageBackup.bat on my tips page and modified it. When a team of developers has to migrate jobs then they need to give us a form with the job names, routine names, shared containers and whetever else they need. We cut and paste this list of jobs into a text file called JobList.txt. Th...

wow.

Ray, I do not think you are typical. I think you are a lot more organized than most. Even with you the first step is very manual. We as a group should look at our manual steps and try to automate them. I want to see the lovel of effort people go through to do these steps. The LOE to install and main...