Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Win32_LogicalDisk via Agent: job never finishes Expand / Collapse
Author
Message
Posted Tuesday, June 24, 2008 12:35 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Monday, July 07, 2008 10:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:40 AM
Points: 89, Visits: 318
anyone... pleezzzeee....
Post #529482
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse