Cannot run a batch file from SQL Server Agent (Access denied) -
i trying execute batch file sql server agent (as needs done before ssis-packages run). when execute job fails in few seconds saying "access denied".
the account under sql server agent runs has full control on folder contains batch file. result of batch deleting files in folder, calling webservice , same files webservice. can run batch file when start own (admin) account.
i googled , found several other questions , answers none of covering problem. hope can point other options.
thanks help.
johan
batch file contents:
echo removing txt files of last run del employees.txt del hrdepfun.txt del hrempactual.txt echo files removed echo starting getconnectors {call webservice} -> cannot disclose on stackoverflow echo getconnectors done
batch file execution statement sql server agent job (type operating system (cmdexec)):
cmd.exe /c "c:\program files (x86)\afas\afasremote_call_getconnectors.bat" > connectorlog.txt 2> connectorerrorlog.txt
Comments
Post a Comment