DSXchange

Sir,

I have job with one source and one target with 3 links one for Insert and another for Update and another for Reject.

How can i get counts for all input links and output links means

source count,insert count,update count and reject counts along with job name,jobstaus and start and end times.

Thanks in advance.

Reddy

Find the "active stage finishing" entry in the log - this contains all the link row counts. Otherwise use DSGetLinkInfo() function in the DataStage API in your own routine.

Download EtlStats from my tips page.

Use DSGetJobInfo() also....

Thanks,
Anupam

Hi reddy,

If you have Asential Meta Stage you can use it to get detailed information about the count, records,jobname etc...

Regards
Sreeni

Sir,

Suppose if i use DSGETJOBINFO() in the jobcontrol of a jobs and i am using jobsequencer how can i get link counts for all jobs.

Thanks
Reddy

You need to have a pre-process and post-process either at each job level that gives you the row count.

Or you can call the Pre and Post process jobs through your sequencer.

Suggested design

Master Control Sequence
|

Job1Seq(Pre - Job1 - Post)
Job2Seq(Pre - Job2 - Post)
Job3Seq(Pre - Job3 - Post)
.....

The Pre and Post are jobs that do the count by calling the APIs.
Job1, Job2 and Job3 are your main jobs to be run.

Job1Seq .. are the sequencers.

Excellent Thanks a lot guys.