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
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