in
Questions and answers to issues related to Software: Business, Database, Firewalls, Office, Graphics, Security, System, Server. » Database » 4GL » Btrieve » executing batch file on newwork drive

executing batch file on newwork drive

I have a batch on the network drive
S:\Admin\PartRack\Junebatch.bat
In map network drive, S corresponds to "\\PND04\ISO$"

what is the command in the sql job to execute it?

thanks

Solution: executing batch file on newwork drive

Use SQLCMD and provide the path like

SQLCMD -U username -P password -S Servername -i input_file_name -o output_file_name

eg:

SQLCMD -U username -P password -S Servername -i S:\Admin\PartRack\Junebatch.bat -o S:\Admin\PartRack\Junebatch.out

Popular Tags

Browse All Tags