Shell Programming and Scripting

Hi
I need some help to write generic shell script for the below log file
Requirement : Get some values from this log file and load them into one stats tables
1. Initializing session time (it will be available in first line) it is start time of the the job.
2. Target Load Summary variables like Table name, Output Rows, Affected Rows, Applied Rows, Rejected Rows. These values need to be loaded one table, Here sometimes Load Summary will be one time or many times as it depends on the job.
3. Endtime of the job it will be available in last line.
4. I want to pass 3 variables to this script
a. job name
b. sub jobname
3. location where the log file stores.
finally i want few parametars like below mentioned so i can insert them into table.
Values need for:
Starttime
job name
sub job name
Location
Table name,
Output Rows,
Affected Rows,
Applied Rows,
Rejected Rows.

-----
log file
------

DIRECTOR> TM_6014 Initializing session [s_LoadPaymethod] at [Tue Mar 20 11:02:00 2012].
ANAGER> PETL_24005 Starting post-session tasks. : (Tue Mar 20 11:02:05 2012)
MANAGER> PETL_24029 Post-session task completed successfully. : (Tue Mar 20 11:02:05 2012)
MAPPING> TM_6018 The session completed with [0] row transformation errors.
MANAGER> TE_7216 Deleting cache files [/devl/infa/v9/Cache/PMJNR15328_10_0_387389.dat] for transformation [JNRTRANS].
MANAGER> TE_7216 Deleting cache files [/devl/infa/v9/Cache/PMJNR15328_10_0_387389.idx] for transformation [JNRTRANS].
MANAGER> PETL_24002 Parallel Pipeline Engine finished.
DIRECTOR> PETL_24012 Session run completed successfully.
DIRECTOR> TM_6022
SESSION LOAD SUMMARY
================================================
DIRECTOR> TM_6252 Source Load Summary.
DIRECTOR> CMN_1740 Table: [SQ_Shortcut_to_SBL_PAY_METHODS_VW] (Instance Name: [SQ_Shortcut_to_SBL_PAY_METHODS_VW])
Output Rows [33341], Affected Rows [33341], Applied Rows [33341], Rejected Rows [0]
DIRECTOR> CMN_1740 Table: [S_ORG_EXT_BU_C] (Instance Name: [S_ORG_EXT_BU_C])
Output Rows [28464], Affected Rows [28464], Applied Rows [28464], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [R_ORG_EXT_XM] (Instance Name: [Shortcut_to_R_ORG_EXT_XM])
Output Rows [33300], Affected Rows [33300], Applied Rows [33300], Rejected Rows [0]
DIRECTOR> CMN_1740 Table: [R_ORG_EXT_XM1] (Instance Name: [Shortcut_to_R_ORG_EXT_XM])
Output Rows [31000], Affected Rows [31000], Applied Rows [31000], Rejected Rows [0]
DIRECTOR> TM_6023
===================================================
DIRECTOR> TM_6020 Session [s_LoadPaymethod] completed at [Tue Mar 20 11:02:05 2012].

Highly appreciated your help.
Thanks,

---------- Post updated at 11:44 AM ---------- Previous update was at 10:03 AM ----------

Hi,

Please let me know incase of any further details are needed for this request.

Thanks,