Home > database >  Powershell & SQL Jobs - Passing errors so job step will fail
Powershell & SQL Jobs - Passing errors so job step will fail

Time:04-13

Good Day folks,

I hope someone can help me here. I am a complete powershell n00b and I've been tasked with the following.

We have a SQL Server 2019 job which runs several stored procedures and then we have a step which calls a powershell command on a remove server. The command we run currently is:

INVOKE-COMMAND -ComputerName remoteServer -ScriptBlock {D:\EXEs\application.bat 35 0 0 0 [PathDirectory] 0 A}

This batch file is simple. It looks like:

@echo off
set CUR_YYYY=           
  • Related