SQL Job running powershell script

chrislindsay
chrislindsay used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Transport Ninja
Commented:
Have you tried replacing New-Object with Invoke-WebRequest?  Seems like it could work depending on the requirements.  Are you running the Scheduled Task with elevated perms?
chrislindsay

Author

Commented:
THe SQL job wasn't running as an executable admin so didnt work.  Once corrected it worked well.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial