Monday, May 18, 2015

windows - Running batch file through a service

I'm trying to schedule a batch file to run through a third party application, however the output file doesn't get created in the directory. If I run the .BAT file from the command line, it works and the file gets created. Also using the Windows Schedule will also succeed.


Basically, the 3rd party software will schedule the .BAT file and it shows success within the 3rd party user interface. The difference between running from the command prompt and the software, is that the software will use its Windows service to launch the batch.


The 3rd party software will show success since it was able to successfully call the .BAT file to run, however it has no control of the other EXE's that's being called within the script.


I'm able to run a simple .BAT file in the 3rd party software, for example a copy command.


The .BAT I'm having problems with calls a compiled EXE which launches Excel to create a file to a location.


The .bat file calls something.exe, which then calls Excel.exe:


C:\something.exe -o D:\filename.xlsm C:\filename.xlsm refresh_pivot


Do you think it's a permissions issue? I used Process Monitor to verify any Access Denied errors but everything seems to be working according to the trace. It worked on a non-64-bit OS, I'm currently using Win2008 64-bit.

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...