Glad to have found this board.
I have a VB Script that is exporting a query to an excel file. It works perfectly when I run it from the command line. When I create a SQL Server Agent Job to execute the same script, it fails.
The type is 'Operating System (CmdExec)' and I'm running it with a Proxy I created. I'm simply calling the vb script that I have saved on a network drive:
It executes, and when I look at the Job Activity log I see the following error:
Microsoft VB Script Error: Active X component can't create object 'Excel.Application' -- referencing the following line of code:
OApp = CreateObject("Excel.Application")
Again -- this works perfectly fine when I run it from the command line, but errors out here. Perhaps there's something basic I'm missing. Thanks in advance for any advice you might have.