SQL Jobs not being listed with Powershell

Question

Using the powershell code below, the script runs and nothing happens. There ARE existing Jobs. And the Server name is correct. No error, it just runs and immediately returns.

$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("sql01") 

$srv.JobServer.Jobs | Where-Object {$_.Name -notlike "sys*"} | Select Name

Any ideas?

Thanks!

what happens if you leave the where-object out? – Mike Shepard Nov 03 '15 at 15:36 — Mike Shepard, Nov 03 '15 at 15:36
Same thing. I have figured it out, see below. Thanks! – A.G. Nov 03 '15 at 15:57 — A.G., Nov 03 '15 at 15:57

score 0 · Answer 1 · answered Nov 03 '15 at 15:57

I ended up doing this and it worked:

$outnm = ".\" + $svr + "\" + $instnm + "_Jobs.csv"  
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "exec msdb.dbo.sp_help_job"
$SqlCmd.Connection = $cn
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$SqlConnection.Close()
$DataSet.Tables[0] | Select originating_server, name, description, owner,     last_run_date, enabled | where {$_.Name -notlike 'sys*'} | export-csv -path $outnm -noType

SQL Jobs not being listed with Powershell

1 Answers1