Wrapper jobs

saratha14 · Post by **saratha14** » Fri Apr 25, 2008 9:50 am

Explain me about wrapper jobs which is used to kick of the child datastage jobs?

ArndW · Post by **ArndW** » Fri Apr 25, 2008 10:12 am

Everyone uses a different definition of a what a "wrapper job" could be. In my case I look at job sequences as wrapper jobs.

kumar_s · Post by **kumar_s** » Fri Apr 25, 2008 12:20 pm

Or is there any what, in your site, you using, wrapper stage to call job in it using dsjob command??

Sudhindra_ps · Post by **Sudhindra_ps** » Fri Apr 25, 2008 4:08 pm

hi,

You could make use of External Source stage to invoke OS scripts which uses Datastage API to trigger an ETL job. Now you could use this external source stage in your parallel job canvas. This master job which invokes other Datastage jobs are called as Wrapper jobs.

Thanks & regards
Sudhindra P S

Sudhindra_ps · Post by **Sudhindra_ps** » Fri Apr 25, 2008 4:10 pm

hi,

You could make use of External Source stage to invoke OS scripts which uses Datastage API to trigger an ETL job. Now you could use this external source stage in your parallel job canvas. This master job which invokes other Datastage jobs are called as Wrapper jobs.

Thanks & regards
Sudhindra P S

kduke · Post by **kduke** » Fri Apr 25, 2008 8:20 pm

Wrapper jobs used to be called "Batch" jobs. Batch jobs were the original sequences.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 26, 2008 6:22 am

I'm still not certain what the original question means. Is it, perhaps, an interview question that you have faced?

saratha14 · Post by **saratha14** » Tue Apr 29, 2008 9:29 pm

ray.wurlod wrote:I'm still not certain what the original question means. Is it, perhaps, an interview question that you have faced? ...

Hi ray,
In my project we are running the Datastage jobs through peoplesoft environment. I have a set of jobs in Datastage that inturn triggers someother datastage jobs. As for as understanding it could be a sequencer.

Thanks,
Saran.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 29, 2008 9:39 pm

A suite of job sequences is the "within DataStage" solution.

If you are using a third party scheduling tool, then you need to create some scripts based around the DataStage command line interface, the dsjob command.