asked
poweshell script wont succeed from sql agent
My script will only return the 1st server in the serverlist.txt $QueryPath= "D:\SQLQueries\BackupsCompleted.sql" $OutputFile = "D:\Outputs\backupscompleted.txt" $ExecuteQuery= Get-Content -path $QueryPath | out-string "Results -- > `r`n`r`n" > $OutputFile FOREACH($server in GC "D:\Serverlists\ServerList.txt") { $server >> $OutputFile "---------------------------------------------------------------------------------------------------------" >> $OutputFile invoke-sqlcmd -ServerInstance $server -query $ExecuteQuery -querytimeout 65534 | ft -autosize | out-string -width 4096 >> $OutputFile }
I usually put the servers in a CSV list then use Import-CSV. In the CSV simply have the heading then list the servers to check. You can then import the CSV i.e #gather list of servers $Servers = Import-CSV "D:\Serverlists\ServerList.csv" #invoke sql on each server FOREACH($server in $Servers) {...... Think that should do it for you :)
18 People are following this question.
