Win32_LogicalDisk via Agent: job never finishes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Win32_LogicalDisk via Agent: job never...

Win32_LogicalDisk via Agent: job never finishes

Rate Topic

Display Mode

Topic Options

Author

Message

tew

Posted Tuesday, June 24, 2008 12:35 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:40 AM
Points: 89, Visits: 318

Hi everyone,
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 ?

Post #522825

tew

Posted Monday, July 07, 2008 10:52 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:40 AM
Points: 89, Visits: 318

anyone... pleezzzeee.... Sad

Post #529482

« Prev Topic | Next Topic »

Permissions