DSXchange

The Job Log we currently have is very limitted and only indicates if the job is successful or not.

Is there any sample code to add to the script to give the following details
A)
i) Job Status
ii) Number of Rows Written
iii) Number of Rows Looked up

B)
how do I get the director log for a particular run to be output into the batch log ?

A) ETLStats. Say 'Thank you Mr Kim.'

B) See A.

Thanks but how do I accomplish the above using a shell script....
it seems that is much simpler....

chulett wrote:A) ETLStats. Say 'Thank you Mr Kim.'

B) See A.

What? Reinventing the wheel is easier than using an already-invented wheel? Please reconsider.

It's definitely NOT "much easier using a shell script, since the job logs are database tables.

I already have a shell script to give me the jobs status but I am trying to add the number of records extracted and written.....I am not sure which variable/parameter to use. How do I find that out ?

I was able to get what I needed using Kim's Doc but I also want to try the above. Thanks

The job that can extract row counts from old log records is written in BASIC. You might be able to use dsjob -logsum or -logdetail to get what you want. If you want the last run only then dsjob -report will give you that.

Maybe you could also use dsjob -linkinfo, with a lot of preliminary mucking about to determine the stage name and link name.