dsjob command

senthilt1 · Post by **senthilt1** » Mon Jul 12, 2010 11:49 pm

HI All,

How to execute a datastage job by folder wise using unix shell script(dsjob)?

Eg., I want to run all the datastage jobs only under a particular folder Jobs/Customer(folder) for a project.

Is it possible?

Also how to find the total no of records passed on to the target Dataset or table thro unix shell script(dsjob)?

Please let me know. Thanks in Advance.

Senthil Kumar P

-

ray.wurlod · Post by **ray.wurlod** » Tue Jul 13, 2010 1:21 am

Not obvious but possible. You first need a query to determine which jobs are in a particular folder, then construct a looping script based on this list to run the jobs. If you already have the list of jobs, then the list can be hard coded.

Row counts can be had from the -stageinfo option of dsjob, if I recall correctly.

senthilt1 · Post by **senthilt1** » Tue Jul 13, 2010 7:54 am

Thanks Ray for the info.

Using the Stage info i could get the row count details. Stage info for the Dataset stages are not working. In my job i have more than one target dataset, if so how should i know the record count of my Target dataset.

At least i want to get the record count of all the datsets(source or target) used in a job.

Please suggest.

Thanks,

Senthil P

ray.wurlod · Post by **ray.wurlod** » Tue Jul 13, 2010 2:23 pm

Submit an enhancement request to get the stageinfo functionality to work with Data Set stage. Currently is doesn't, which most regard as a bug or at least a deficiency. Hey, it may already be fixed - check on Fix Central.