![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| Guest | How to output a powershell into a sql server 2008 table Hy all, my english is veru bad so i try to explain I get this script in the net and works percetly [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-null foreach ($svr in get-content "C:\AllServers.txt") { write-host $svr $srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "$svr" $srv.jobserver.jobs | where-object {$_.lastrunoutcome -eq "Failed" -and $_.isenabled -eq $TRUE} | format-table name,lastrunoutcome,lastrundate -autosize } It´s list all sql server agent jobs with error in my servers. Ok I want to know how a output this into (uning this script) a sql server 2008 table and some kind of file (csv..txt) Thanks a LOT |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| table type formatted output in powershell | PowerShell | |||
| SQL Server 2008 and PowerShell v2 | PowerShell | |||
| powershell in vista / server 2008 - gui (longhorn) | PowerShell | |||
| Getting Powershell output into a sql table | PowerShell | |||
| Where is Powershell in Server 2008 | PowerShell | |||