Making a counter process that periodically dumps amount of messages into a text file
We're doing a small data integration project at our university and I've run into a problem.
I'm trying to make a counter that records the amount of messages (a simple .txt file transfer) that pass through a process and dumps that amount into a text file (preferably with a timestamp) every 10 minutes or so.
What I've gathered it's possible to do it via SQL query but linking that query into a process is something I haven't found any info on.
Are there any semi-beginner friendly ways to do this?
Thanks in advance!