Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Spooling a file to a drive.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-14 : 22:06:08
Gaurav writes "PROBLEM:

We have a unix script (.ksh) which takes a back up of the repository . This has to be done every evening ( manually ).

We need to automate the task.
In SQL enterprise manager we can create task , design the steps( workflow) and then exceute a SQl script to finish the exection of the job.

Well I created JOBS, had the workflow in place.

Now the problem is :

I need to write a script that will spool the file to the drive and save it as a NAME_DATE

Can you guys help me out.
Thanks and regards,
Gaurang"
   

- Advertisement -