troubleshooting Question

SQL Job running powershell script

Avatar of chrislindsay
chrislindsayFlag for United Kingdom of Great Britain and Northern Ireland asked on
PowershellSQL* job
2 Comments1 Solution153 ViewsLast Modified:
Hi Experts,
I am having issues with a SQL powershell job I have created :-

$IE=new-object -com internetexplorer.application
$IE.navigate2("https://abc.com/Data")
$IE.visible=$false



 The job ran 13 times (scheduled) with no issues then stopped running reporting the issue below :-

A job step received an error at line 1 in a PowerShell script. The corresponding line is '$IE=new-object -com internetexplorer.application'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Retrieving the COM class factory for component with CLSID {0002DF01-0000-0000-C000-000000000046} failed due to the following error: 80080005.

The account that is running the job has full local permissions.  The scanning and anti malware has been turned off

Any help would be appreciated.

Cheers

Chris
ASKER CERTIFIED SOLUTION
Jason Crawford
Transport Ninja

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros