A process I use is to process all the files in the directory, touch a
dummy file, then check again in a minute (every minute) and process any
files newer than the dummy file, touch the dummy file, rince, repeat.

A new file comes in in 8 minutes? Fine, the 9 minute check will catch
it. 12 minutes? OK, the 13 minute check will get it.

No file will 'sit and wait' for more than 60 seconds before being
processed.

This works based on file creation time only, without reguard to the file
name (although you can use the file name without difficulty...)

I use touch and find in my cron script. MAN FIND and MAN TOUCH will get
you details.

I use the ! -newer parameter to TOUCH

HTH

Walt



Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


From: Zelli Brian
[mailto:oracledba-ezmlmshield-x14480005.[Email address protected]
Sent: Thursday, May 31, 2007 14:49
To: LazyDBA Discussion
Subject: scripts

Ok, I need to sqlload files as they come into a directory. They come in
every ten minutes. But it is not a set ten minutes. Only when there is
data to pump across. Does anyone have a unix script that can
accommodate something like this? the files come in with a timestamp as
part of the name. I was able to cron a job that handled a once a day
process but not something like this. Or if you have ideas, white
papers, website that I can look at.........

ciao,
Brian






This email message may contain legally privileged and/or confidential
information. If you are not the intended recipient(s), or the employee
or agent responsible for the delivery of this message to the intended
recipient(s), you are hereby notified that any disclosure, copying,
distribution, or use of this email message is prohibited. If you have
received this message in error, please notify the sender immediately by
e-mail and delete this email message from your computer. Thank you.

Oracle LazyDBA home page