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

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -