Here's a Powershell version. Use the first line if you're running from a Powershell session with SQL 2008 DLLs. The second line if you only have SQL 2005...

Here's a Powershell version I use. If you want all jobs, enabled or not, just remove the "if ($job.isEnabled) {" line and it's matching "}"

add-type -AssemblyName "Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral,...

[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"

$jobList = $srv.jobserver.jobs | where-object {$_.lastrunoutcome -eq "Failed" -and $_.isenabled -eq $TRUE}

foreach($job in $jobList) {

$sql += "Insert YourTableName...

That's what I was trying to point out but I guess I didn't phrase it correctly.

Get-Item, when looking for file info, should be your friend.

If it's a small file that's fine but when working with larger files you'll find a difference in performance between using Get-Content and just looking at the file size.

Glad you worked it out but I thought I'd give you another option.

if ($(Get-Item -Path c:\scripts\sysevents.txt).Length -gt 0) { "Send mail" }

else { "Don't send" }

And I agree with ALXDBA,...

If you write $result to the console you'll probably see the error right off. Try changing

foreach ($Source in $result)

{

$src = $_.Source

$dest = $_.Destination

...

To

foreach ($Source in $result)

{

$src = $Source.Source

$dest...

Beejug1983, I just want to bring up a couple of final points regarding the script I posted and some of the things Steve, Jeff and opc.three have brought up. ...

Get-WmiObject -Class Win32_OperatingSystem |Select Description

No offense taken Jeff, it’s a reasonable question. I posted the Powershell since the OP asked in this forum. The answer would have been different if the question...

Very good point Steve. I was trying to show the how, not specific values but I should have made that clear.

At least I first showed how to set the...

This is for one server and includes system databases but I expect you know how to change to your requirements. The single commented lines are where you can change...

No real answers here just questions. May be things you’ve already looked at.

1. What account is running the job, does it have the needed permissions?

2. Is the...

I'm not sure I understand what you changed or why your previous code didn't work. If you want to send any error messages from your prior version maybe we can...

Nothing in that script is directed to an output file. Modify the script to send the results to a file if that's what you want. (change C:\data\AllServersResults.txt to whatever...