I am running a PowerShell SQL job to synch logging between the nodes of High availability environment. The command is - C: \Windows\System32\WindowsPowerShell\v1 .0 \PowerShell.exe - Command "Copy-DbaLogin -Source XXXDC1SQL2 -Destination XXXDC2TSQL2". Th job completes successfully but output is " Executed as user: NGH-AD\XXXXXXX The step did not generate any output. Process Exit Code 0. The step succeeded."
On running the same in PowerShell "Copy-DbaLogin -Source XXXDC1SQL2 -Destination XXXDC2TSQL2" the output is available.
I have checked permission as SQL server service account is sysadmin on both SQL nodes and is in administrator group of the servers.
What I am missing?
SQL server 2019 with OS 2019