I hade the same problem. Several different SQL servers on different networks. Therfore I scheduled the scripted collection from one computer and read the file there or I can send...

How about a .vbs script that collects the failed jobs to a text file?

MakeLogNonTrusted "UntrustedServer", "sa", "password"

MakeLogTrusted "MyTrustedServer"

sub MakeLogTrusted (ServerName)

Const adOpenStatic = 3

Const adLockOptimistic = 3

Const adUseClient = 3

Set objConnection...