Reading the DSJobReport file
Posted: Thu Mar 27, 2008 8:21 am
Hi All,
I have used an after Job routine "DSJobReport" to generate the reports.
I have also got a text file with all the information on the file.
But there is some junk characters in between each filed.
So how do i get rid of these junk characters or how do i read this text file in an Sequential stage?
I have attached the report i.e. the contents of the text file along with this post.
**************************************************
STATUS REPORT FOR JOB: Job1
Generated: 2008-03-27 19:36:08
Job start time=2008-03-27 19:35:31
Job end time=2008-03-27 19:36:08
Job elapsed time=00:00:37
Job status=2 (Finished with warnings)
Stage: Sequential_File_0, 4 rows input
Stage start time=2008-03-27 19:35:49, end time=2008-03-27 19:36:04, elapsed=00:00:15
Link: TO_Sort, 4 rows
Stage: Sort_3, 4 rows input
Stage start time=2008-03-27 19:35:49, end time=2008-03-27 19:36:07, elapsed=00:00:18
Link: TO_Sort, 4 rows
Link: TO_Trnsfrmr, 4 rows
Stage: Transformer_6, 4 rows input
Stage start time=2008-03-27 19:35:52, end time=2008-03-27 19:36:07, elapsed=00:00:15
Link: TO_Trnsfrmr, 4 rows
Link: TO_Reject, 2 rows
Link: TO_Target1, 2 rows
Stage: Reject, 2 rows input
Stage start time=2008-03-27 19:35:52, end time=2008-03-27 19:36:07, elapsed=00:00:15
Link: TO_Reject, 2 rows
Stage: Target, 2 rows input
Stage start time=2008-03-27 19:35:52, end time=2008-03-27 19:36:07, elapsed=00:00:15
Link: TO_Target1, 2 rows
I have used an after Job routine "DSJobReport" to generate the reports.
I have also got a text file with all the information on the file.
But there is some junk characters in between each filed.
So how do i get rid of these junk characters or how do i read this text file in an Sequential stage?
I have attached the report i.e. the contents of the text file along with this post.
**************************************************
STATUS REPORT FOR JOB: Job1
Generated: 2008-03-27 19:36:08
Job start time=2008-03-27 19:35:31
Job end time=2008-03-27 19:36:08
Job elapsed time=00:00:37
Job status=2 (Finished with warnings)
Stage: Sequential_File_0, 4 rows input
Stage start time=2008-03-27 19:35:49, end time=2008-03-27 19:36:04, elapsed=00:00:15
Link: TO_Sort, 4 rows
Stage: Sort_3, 4 rows input
Stage start time=2008-03-27 19:35:49, end time=2008-03-27 19:36:07, elapsed=00:00:18
Link: TO_Sort, 4 rows
Link: TO_Trnsfrmr, 4 rows
Stage: Transformer_6, 4 rows input
Stage start time=2008-03-27 19:35:52, end time=2008-03-27 19:36:07, elapsed=00:00:15
Link: TO_Trnsfrmr, 4 rows
Link: TO_Reject, 2 rows
Link: TO_Target1, 2 rows
Stage: Reject, 2 rows input
Stage start time=2008-03-27 19:35:52, end time=2008-03-27 19:36:07, elapsed=00:00:15
Link: TO_Reject, 2 rows
Stage: Target, 2 rows input
Stage start time=2008-03-27 19:35:52, end time=2008-03-27 19:36:07, elapsed=00:00:15
Link: TO_Target1, 2 rows