Getting server.log and error.log details

Hi,
How can we automatically sent the transaction details ( including successful and failed transactions) to a Database every hour. Need to get the transactions details from the PROD server and sent that to a Database.
Any kind of help will be highly appreciated.

Thanks
Soumodip

why do you want to get the details from the log files, you can directlt insert the Success and failure details to your local database with flag. Setup the scheduler which executes for every hour which pushes the data from your local DB to remote DB.

Thanks a lot for your reply. Understood about the 2nd part ( i.e using a scheduler to push data from local Db to remote Db), but can you please kindly elaborate a bit on the first part i.e about “directly insert the Success and failure details to your local database with flag”.

Thanks in Advance