I have a folder c:\test
I get 4 files in it: PX.txt, PXDelta.txt, NX.ext and NXDelta.txt
I need to monitor this folder for these files. Call a stored proc to import them into a table (i have this code already) and rename the file (i have this as well)
Can I monitor a folder to see if a new file by name of PX.Txt is copied into that folder with a SQL job?