kaps wrote:shobhit - That's what I am doing and storing the result in a table.
@kaps
1)cd `cat /.dshome`
2)cd bin
3)dsjob -report project_name job1
when i run above commands i am getting following output for a particular Job
STATUS REPORT FOR JOB: Test_Seq
Generated: 2012-06-15 05:28:24
Job start time=2012-06-08 08:36:14
Job end time=2012-06-08 08:36:18
Job elapsed time=00:00:04
Job status=1 (Finished OK)
Status code = 0
I want to load above information in a table and table is having 5 coulms(Generated,Job_start_time,Job_end_time,Job_status and Job_elapsed_time)
The problem is If i am able to write this information into a delimited file i can load into a table.could anybody please help on this to write this information into a delimited file to load into target table?