I create daily reports and send them using the FTP function in TOAD. I current overwrite the previous file, or add each day’s new report to their folder. I was asked if it were possible to only have the 5 most current reports in their folder. For example, if I ran the report today, Friday. In their folder, they would want to see today’s most current report plus Monday thru Thursday’s reports of this week.
I see there is a mask function for last week, but I don’t think that will capture this week’s reports. There is also a custom date, but I do not want to go in every day and modify the date range.
Does anyone have any ideas if this can be done or how to do it?