Joined: 26 Apr 2004 Posts: 4650 Location: Raleigh, NC, USA
I work in Data Transmissions and we send lots of files everyday via FTP, SFTP and NDM with variable filenames. We either use Scheduler variables, system variables, or a combination of both. All of our jobs use a PROC of some sort.
We either use Scheduler variables, system variables
I think using the scheduler variables would be more reliable than the SORT solution I posted. Since the SORT solution dates would vary if the job failed and the restart happens in the following day. Scheduler variable however would remain the same, if needed.
The SORT solution was for a quick and dirty user job.