There is no simple mechanism in Monarch or Data Pump to do this.
One solution in Data Pump would be to create a specific folder where new files are to be processed.
Then, monitor this folder for new files, using a wildcard file specification that would fit the filename that will be assigned.
As part of the monitoring, the new file will be moved to a folder that you specify, so you can keep the processed files for archival purposes.
I've already setup a project export in MonarchPro v8 to export to an Access database, but want Datapump to pull the appropriate file according to today's date. e.g. file to process = today's date in "yyyymmdd.txt" format.
a) Should I use a batch program to calculate today's date and somehow convert that into yyyymmdd.txt as a command line parameter for monarch?
b) If I do (a), do I just call the batch file from datapump?
c) Can I use Monarch to calculate the name of the report to load instead of Datapump doing it?
d) Is there a better (see, 'easier') way which I'm not aware of, using Datapump directly?