Status Report for Job

uegodawa · Post by **uegodawa** » Wed Mar 04, 2009 3:01 pm

I would like to know answers for following questions.

1. Is your Tgt_StagingArea is a Flat File ?

2. If 'Yes' have you enabled 'output column names' to True ?

If 'Yes' this explains why you got addition record in your output rather than input.

swades · Post by **swades** » Wed Mar 04, 2009 3:15 pm

Here is the answers

1. Is your Tgt_StagingArea is a Flat File ? Yes

2. If 'Yes' have you enabled 'output column names' to True ? No

Also I checked this Flat File on Unix, there is one record (NOT COLUMN NAME)

swades · Post by **swades** » Thu Mar 05, 2009 2:09 pm

No one has a clue

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 06, 2009 7:52 am

Few Questions

1. How you are generating the report?
2. posted logs are complete?
3. What is the value of environment variable APT_NO_JOB_MON?

swades · Post by **swades** » Fri Mar 13, 2009 10:33 am

priyadarshikunal wrote:Few Questions

1. How you are generating the report? From notification activity (Include job status in email)
2. posted logs are complete? Yes
3. What is the value of environment variable APT_NO_JOB_MON? False (Set at Administrator level)

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 13, 2009 11:44 am

Seems to me like its generating report for wrong instance or datastage is facing some problem in reading it.

The job started at 02:05:40 in report its 02:05:38.

first check whether its happening for other instances too.