Hi all,
I am new comers to this forums. I need one help from urs.
My requirement is to fetch the records from the log file for every 15 mins and write the datas to the new file...
The log file which is located in the 21/09/2008 directory.
In 21/09/2008 directory, number of log files are there.
so every log file contains differnet information respect to the process details.
The log file looks like below:
start time: 22:00
End time :24:00
Process name: abcd
Start date: 21/09/2008
Elapse time: 120mins
when user give these Input parameters are :
Date: sysdate(or any date which user likes)
I want to execute the query automatically every 15 mins.
I want to write the data in the current directory from which we ran the script in the format of .xls file
The output file looks when i give the input parameters date:21/09/2008
it will search all the files which is located in the 21/09/2008 directory and read into the .xls file
process name start date elapse time start time end time
abcd 21/09/2008 120mins 22:00 24:00
start time: 22:00
End time :24:00
Process name: abcd
Start date: 21/09/2008
Elapse time: 120mins
please asssit me how to do that...