how to compile jobs thru unix commands and which one to use.

dsxdev · Post by **dsxdev** » Thu Dec 09, 2004 7:31 am

Are there any unix commands to compile Ds jobs. If so can some please tell.

somthing like dscompile.... etc

chulett · Post by **chulett** » Thu Dec 09, 2004 8:02 am

No. You can write a routine to compile jobs but there's no command line option.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 09, 2004 3:38 pm

Even the routine requires knowledge about the internal architecture of DataStage that is not in the public domain.

The safer answer is a plain NO.

There are some job compilation utilities available, including the multi-job compile that now ships with DataStage.

dsxdev · Post by **dsxdev** » Tue Dec 14, 2004 6:03 am

My requirement is to compile a job which is in aborted state and not all.
This work I want to do daily.
Like it is a job which would compile all aborted jobs.

Any routines already available/or macros in DS would be agreat help

battaliou · Post by **battaliou** » Tue Dec 14, 2004 6:38 am

Osh code is generated by the client, ie Designer, so no unix commands can help you to compile here. Remember you should use "force compile" to ensure the entire job is compiled.

Why is your "reset job" not working? Simply generating the same osh should have no benefit for you. I would urge you to revisit the job sequencer options.

chulett · Post by **chulett** » Tue Dec 14, 2004 7:35 am

dsxdev wrote:My requirement is to compile a job which is in aborted state and not all.

As already noted, what you want to do is reset aborted jobs, not recompile them. Whatever you are using for Job Control should be able to handle that automatically. For example, Sequencer jobs can be set to 'Reset Then Run' or hand code can do something similar.

You could even accomplish this from a command line script by using the output of the dsjob command. The "-jobinfo" option will get you the current status and if the job is aborted you can use the "-run -mode RESET" option to get it reset.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 14, 2004 2:29 pm

The Multiple Job Compile tool allows you to be selective about which jobs to compile. For example, you can select only uncompiled jobs.

While it's not clear directly how to select aborted jobs in this tool, I think it's worth investigating.