Home Forums Programming Powershell Cannot use Powershell to UNZIP files inside SQL Job RE: Cannot use Powershell to UNZIP files inside SQL Job

  • Have not tried the Log File trick. Did try capturing the Job Step output to a TXT file but it was blank.

    I did log onto the box using the SQL Agent credentials and was able to run this script successfully in PS and SQLPS. Since the SQL Job is supposed to cal SQLPS.exe to run the script and the script does run when I call SQLPS manually I am at a complete loss as to why it will not run inside a job step.

    Fred