Toad World® Forums

Scheduled Automation question

I am trying to create a scheduled automation where a report is generated WITH a timestamp attached to the filename and then emailed out.

The automation and email process will work fine when I choose NOT to put a timestamp on the file because the email process will know exactly what file to grab and send, but when the timestamp is there, the file name technically will change each day so the email is sent out WITHOUT the file because it couldn’t find it.

Is there a way to work around this in the settings so that the email process will find the file with that newest timestamp to attach?

When you append a timestamp to a report we use a variable to do this. When you use the attachment editor of the send email activity, it should display your report with the variable string we use. It looks like NameofFile#yyyy-MM-dd HH-mm-ss#. If you select to attach that file the email will locate it with the correct timestamp generated. See screenshot. This will get you what you need

Debbie

Excellent. Thank you Debbie