I have a scheduled task to runs a backup script each night using a program called SQL_Talk for Windows version 9.0.1. I am using this program to unload a SQLBase database each night for backup purposes. I have a separate script for each night of the week. Below is the Monday script:
set server server1;
connect testdb 1 sysadm/XXXXXX;
update statistics on database;
SET BULK ON;
unload database z:backupsVIS_Monday.UNL;
Instead of unloading to a file named VIS_Monday.UNL
is it possible to change the script to embed the date of the unload in the filename? For example VIS_Feb232009
This would make for fewer scripts and I would not have to manually embed the dates in the file names.
If not, is there another scripting program that will allow this to be done?
February 24, 2009 4:47 PM
March 2, 2009 6:13 PM