Automation - DateTime in extract filename

Toad for Oracle
1

I'm using the automation utility and will be extracting row counts before I start the data extract (separate automation apps).
I was wondering if there was an easy way to add a datetime to the file name. I'm new to Toad so I don't have a lot of experience with a lot of the functionality available in Toad.

Thank you in advance,

John

2

You can put in a file name with variables, such as c:\temp\%DATEFILE%.txt and Toad will substitute in the value when you run it.

To see all available variables, right-click in the filename box and choose "Variables".

1 Like