SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Thursday, August 03, 2006

Executing Batch Files Using SQL Agent

I wrote a simple batchfile which takes a copy of our source files. I wanted to execute that via SQL Server Agent. Batchfile works fine when I execute on a command prompt.

To get the batch file to execute via SQL Agent I have to use CALL command.

In my scenario
CALL E:\Data\FTP\CopySourceFiles\SourceFile_Backup.bat

Thanks
Sutha

0 Comments:

Post a Comment

<< Home