I've written a sql to run a few heartbeat checks on our oracle database. Within the sql I've added a spool command. I'd like the filename to include the today's date so that it does not overwrite other outputs from the previous days. A batch file will run the sql. Here is the sample:

spool u:\oracle\analyzescripts\heartbeat&timestamp.lis

--
--
spool off

Haven't run the script yet but would like to know if I've missed anything. Will this work with batch files?

Thanks

x indicates an ampersand.

[Edited by pando on 03-18-2002 at 09:14 AM]