I've written a VBS script whose purpose is to report disk details. The script calls WMI classes to capture and report disk information. The script runs fine in a Visual Basic IDE, but when I port the script to SQL Server 2005, the following call results in the Agent Job never finishing.
Set DiskVolume = objWMIService.InstancesOf("Win32_LogicalDisk")
The Agent service has local admin as well as a logon account with Sysadmin privs (it's a development box). No errors are returned by any SQL Logs or O/S logs. I'm running the vb script directly from an Agent job, not a stored proc or SSIS package.
Any ideas ?