Challange for Experts (Monitoring Log files)
Posted on 2006-06-19
Dear VB Experts,
I need to build new applicatio using VB 6.0 to monitor a log file in a server, with frequintly repeated check every period og time, the program has to detect if there is any new jobs recorded in the log file or any updates on an already existing job in this log.
Now if there is new job, a new record must be inserted in a table in SQLserver DB with incompleted status, and recheck again for new and updates. if there is new jobs then insert again else check for the aleardy inserted jobs and not completed if there is any updates or modifications to update the status.
So, My procedure is a monitoring for a log file in a fax server, each fax job has more than one record one when just entered the accepted and the ready to be sent finally its successfully sent or not. so i need to check, insert if new or update if existing and check again.
Please advice ASAP
Thnx in advance